Results 1 to 4 of 4

Thread: MOD and Conditional Formatting

  1. #1

    MOD and Conditional Formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I was told in a course that I could use MOD() for Conditional formatting - shading every other row -- but wasn't told how. Can someone please tell me how to do this?

  2. #2
    Good morning,

    Certainly. If you want to shade every other row use:

    =MOD(ROW(),2)

    You can use similar logic to shade every third row, every other column, etc.

    Best of luck,

  3. #3
    Where do I put the formula and how does it know to shade?

  4. #4
    Sorry I left off the last of the formula.

    It should read:

    =MOD(ROW(),2)=1

    Go to conditional formatting and select the option to use your own formula. Paste that in and set your formatting.

    MOD takes the remainder. This takes the row # divided by two, so even rows will have a remainder of 0, while odd rows will have a remainder of 1. All of the 1's get formatted and all of the 0's are blank.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •