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,
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,
Where do I put the formula and how does it know to shade?
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.
Bookmarks