Zebra Strips using Conditional Formatting

Zebra lines are shading to differentiate between rows. Using conditional formatting and the formula below, you can highlight the 2nd, 3rd, 4th, etc. row as desired. Just place the mod formula inside a conditional formatting box and format the cell shading as desired. Just change the number to indicate which row to highlight.

=MOD(ROW(),2)=0





No comments:

Post a Comment