Thank you . It works wonderfully!

"Domenic" wrote:

Assuming that your range is B5:E10...

1) Select your range

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=MOD(ROW(B5)-ROW($B$5)+0,2)=0

4) Choose your formatting

5) Click Ok

This will highlight every other row starting with the first one. If you
want to highlight every other row starting with the second one, change
the +0 part of the formula to +1.

Hope this helps!

In article ,
Tat wrote:

I would like to add a color to every other row in a specified row/column
range. In addition if a row is inserted I would like it to continue the color
pattern of every other row being colored.