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
