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

Discover how you can alternate column colors in Excel conditional formatting.

Light Row Colour
1) Select dataset.
2) Home ~ Style ~ Conditional Formatting
~ Manage Rules...
3) Use a formula to determine which
cells to format
4) =MOD(COLUMN(),2)=0
5) Format
6) Fill tab
7) Select LIGHT ORANGE
8) OK
9) OK

Dark Row Colour
1) New Rule...
2) Use a formula to determine which cells to format
3) =MOD(COLUMN(),2)=1
4) Format
5) Fill tab
6) Select DARK ORANGE
7) OK
8) OK
9) Apply


Color every 2 rows, starting from the 2nd group.
=MOD(COLUMN()-1,4)