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

Light Row Color
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 Color
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)&gt&lt2
Color every 2 rows, starting from the 1st group.
=MOD(COLUMN()-3,4)&gt&lt2

Color every 3 rows, starting from the 2nd group.
=MOD(COLUMN()-4,6)&gt&lt3
Color every 3 rows, starting from the 1st group.
=MOD(COLUMN()-1,6)&gt&lt3

Color every 4 rows, starting from the 2nd group.
=MOD(COLUMN()-5,8)&gt&lt4
Color every 4 rows, starting from the 1st group.
=MOD(COLUMN()-1,8)&gt&lt4

Color every 5 rows, starting from the 2nd group.
=MOD(COLUMN()-6,10)&gt&lt5
Color every 5 rows, starting from the 1st group.
=MOD(COLUMN()-1,10)&gt&lt5

To shade columns with 4 different colors
Rusty Orange, =MOD(COLUMN()+4,4)=1
Dark Orange, =MOD(COLUMN()+4,4)=0
Orange, =MOD(COLUMN()+4,4)=3
Light orange, =MOD(COLUMN()+4,4)=2

#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.