shade rows

M

Manohar

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

Duke Carey

use conditional formatting

highlight the entire data set, choose Conditonal formatting from the format
menu, choose Formula and set it equal to

=mod(row(),2)=1

then click the format button and choose a Pattern that shades every other
row the way you want

Duke
 
G

Guest

-----Original 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?
.
Try shading a couple, highlight them, copy, highlight the
Click to expand...
rest of the rows to shade, then right click, paste
special, format only.
 
Top