Alternating row color

B

Ben

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
[email protected]
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.
 
Top