How do I alternate row colors in Excel conditional formatting? - Excel Tips and Tricks

Learn how to alternate row colors in Excel conditional formatting. Essentially, how to alternate row color in Excel (highlight every other row)?

Light Yellow Row Colour
1) Select dataset.
2) Home ~ Style ~ Conditional Formatting ~ New Rule...
3) Use a formula to determine which cells to format
4) =MOD(ROW()-2,4)>=2
5) Format
6) Fill tab
7) Select LIGHT YELLOW
8) OK
9) OK

Dark Yellow Row Colour
1) Select dataset.
2) Home ~ Style ~ Conditional Formatting ~ New Rule...
3) Use a formula to determine which cells to format
4) =MOD(ROW()-2,4)+1=2
Color every 2 rows, starting from the 1st group.
=MOD(ROW()-2,4)+1