One way.

Select the rows you want and then select format - conditional formatting -
formula is and enter the formula

=MOD(ROW(),2)

and then select your non-white colour.

Mike

"Jeff" wrote:

I am trying to create alternating row colors. So the first row is a shade of
white and the second row would be a gray color and repeats continuously