coloring every other row in a range

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.
 
D

Domenic

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!
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Coloring the row and column numbering bars in Exce2003 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
using conditional formatting with dates 1
I need to move information from a column on one sheet to another s 7
specify an ending row in an array formula 3

Top