shade rows

M

Manny

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

JulieD

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
 
Top