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. <br />=MOD(COLUMN()-1,4)
