Shading every other line in Excel
Q: In Excel I
have a large table of data I print out regularly. I would like to have every
other row shaded like on old printout paper to make it easier to read along
lines. I've tried doing it manually but when I move data around it spoils
the shading. Is there an easy way to do this which won't get messed up when
I move data.
A: Yes, there is. I use it all the time. You need to select the whole worksheet, then from the 'Format' menu, select 'Conditional Formatting'.
Change the pulldown which reads 'Cell value is' so it reads 'Formula is' and then enter this formula in the empty field:
=MOD(ROW(A1),2)=0
Next, hit the
'Format' button and on the 'patterns' tab choose a colour. The lighter ones
on the bottom row of the palette work best.