shade rows
 

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?

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?

See http://www.xldynamic.com/source/xld.CF.html#rows

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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?