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 Color
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)&gt=2
5) Format
6) Fill tab
7) Select LIGHT YELLOW
8) OK
9) OK

Dark Yellow Row Color
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&lt=2
5) Format
6) Fill tab
7) Select DARK YELLOW
8) OK
9) OK

Color every 1 rows, starting from the 2nd group.
=MOD(ROW(),2)=0
Color every 1 rows, starting from the 1st group.
=MOD(ROW(),2)=1

Color every 2 rows, starting from the 2nd group.
=MOD(ROW()-2,4)&gt=2
Color every 2 rows, starting from the 1st group.
=MOD(ROW()-2,4)+1&lt=2

Color every 3 rows, starting from the 1st group.
=MOD(ROW()-2,6)+1&lt=3
Color every 3 rows, starting from the 2nd group.
=MOD(ROW()-5,6)+1&lt=3

Color every 4 rows, starting from the 1st group.
=MOD(ROW()-2,8)+1&lt=4
Color every 4 rows, starting from the 2nd group.
=MOD(ROW()-6,8)+1&lt=4

Color every 5 rows, starting from the 1st group.
=MOD(ROW()-2,10)+1&lt=5
Color every 5 rows, starting from the 2nd group.
=MOD(ROW()-7,10)+1&lt=5

Color every 6 rows, starting from the 1st group.
=MOD(ROW()-2,12)+1&lt=6
Color every 6 rows, starting from the 2nd group.
=MOD(ROW()-8,12)+1&lt=6

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Please take the opportunity to connect and share this video with your friends and family if you find it useful.