© Ugur Akinci
If you used to know how to color the alternate table rows in earlier versions of MS Excel you need to learn this useful skill again because the method has changed.
There are several methods to do this. Here I’ll cover one such method.
Here is our sample table, without any colors at all:
(1) Select the cells you’d like to fill with alternating bands of color:
(2) Go to the HOME tab on your ribbon.
(3) Select Conditional Formatting > New Rule to display the New Formatting Rule dialog box.
(4) Select “Use a formula to determine which cells to format” for Rule Type.
(5) Enter this formula for Rule Description: =MOD(ROW(),2)=0
(6) Click Format to display the Format Cells dialog box. Select the Fill tab:
(7) Select the color you like and click OK. Back at the New Formatting Rule dialog box, click OK again.
Now the 1st, 3rd, and all the other ODD NUMBERED alternating rows of your table are colored:
(8) If in the formula you change 0 with 1 (=MOD(ROW(),2)=1), EVEN NUMBERED alternating rows will be colored:
(9) If you’d like to have TWO DIFFERENT COLORS alternating, first color the whole background solid in the color you like and then follow all the above steps: