Highlight every other row

[Bri]

Hi
I have a large list of over 3 thousand rows that will be printed. Does
anyone know of a way to have Excel highlight every other row to make it
easier to read across, so I don’t have to do it manually?

Thank You!

see http://support.microsoft.com/?kbid=268568 it does exactly what you want

"Bri" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I have a large list of over 3 thousand rows that will be printed. Does
> anyone know of a way to have Excel highlight every other row to make it
> easier to read across, so I don't have to do it manually?
>
> Thank You!

[Max]

"Bri" wrote:
> I have a large list of over 3 thousand rows that will be printed. Does
> anyone know of a way to have Excel highlight every other row to make it
> easier to read across, so I don’t have to do it manually?

One play ..

Select A1, then press CTRL+A to select the entire sheet
Click Format > Conditional Formatting
Condition 1, Formula is: =MOD(ROW(),2)
Click Format button > Patterns tab > Light green? > OK
Click OK at the main dialog

The above will yield alternating light green rows
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---