Alternating row color

G

Guest

Is there any easy way to make the background color of every second row different in Excel 2003? This is easy to do in Word. I don't want to have to highlight every second row and change it manually.
 
D

Don Guillett

One way is to use format>conditional formatting and the formula
=mod(row(),2)=0 and format as desired.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Ben said:
Is there any easy way to make the background color of every second row
Click to expand...
different in Excel 2003? This is easy to do in Word. I don't want to have to
highlight every second row and change it manually.
 

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

Alternate Row Coloring 6
Worksheet Layout 2
background-color every second row 2
Formula to set cell color 3
How do I create alternating row colors in excel? 5
How to reset every other row color after sorting 2
conditional format - table - cell empty return default color 1
Changing row color for each change in col A 3

Top