coloring every other row in a range
 

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!

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.

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.

This is one of many standard features of ASAP Utilities, available free at
www.ASAP-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Tat" wrote in message
...
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.

Thanks for that info.

"CLR" wrote:

This is one of many standard features of ASAP Utilities, available free at
www.ASAP-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Tat" wrote in message
...
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.