coloring every other row in a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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!
 
Thank you . It works wonderfully!

Domenic said:
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!
Click to expand...
 
Back
Top