Discover how you can alternate column colors in Excel conditional formatting. br br Light Row Colour br 1) Select dataset. br 2) Home ~ Style ~ Conditional Formatting br ~ Manage Rules... br 3) Use a formula to determine which br cells to format br 4) =MOD(COLUMN(),2)=0 br 5) Format br 6) Fill tab br 7) Select LIGHT ORANGE br 8) OK br 9) OK br br Dark Row Colour br 1) New Rule... br 2) Use a formula to determine which cells to format br 3) =MOD(COLUMN(),2)=1 br 4) Format br 5) Fill tab br 6) Select DARK ORANGE br 7) OK br 8) OK br 9) Apply br br br Color every 2 rows, starting from the 2nd group.