Hi Manny
you can use conditional formatting for this, select the rows (using the row
numbers) of your data area and choose
format / conditional formatting
choose
formula is
and type
=MOD(ROW()-1,2)+1<=1
click the format button, go to the patterns tab, choose a colour and click
OK twice
this will format all ODD rows to the chosen background
Cheers
JulieD
"Manny" wrote in message
...
I have lots of data in continuous rows, it is difficult to follow accross
when reading each row on a print out. How do I shade alternate rows in
excell
so every line looks separated without manually shading each row?
|