Learn how to alternate row colors in Excel conditional formatting. Essentially, how to alternate row color in Excel (highlight every other row)? <br /><br />Light Yellow Row Colour <br />1) Select dataset. <br />2) Home ~ Style ~ Conditional Formatting ~ New Rule... <br />3) Use a formula to determine which cells to format <br />4) =MOD(ROW()-2,4)>=2 <br />5) Format <br />6) Fill tab <br />7) Select LIGHT YELLOW <br />8) OK <br />9) OK <br /><br />Dark Yellow Row Colour <br />1) Select dataset. <br />2) Home ~ Style ~ Conditional Formatting ~ New Rule... <br />3) Use a formula to determine which cells to format <br />4) =MOD(ROW()-2,4)+1=2 <br />Color every 2 rows, starting from the 1st group. <br />=MOD(ROW()-2,4)+1
