Format alternate cells

[Guest]

I have a spreadsheet of about 500 rows and additional rows are inserted every now and then. To make it easier to read when printed off, I want to shade alternate rows. Any idea how to do this - except manually?

Thanks, Lisa (UK)

 

[IML]

Highlight your area. Choose conditional formatting from the format menu. Change the drop down box to formula.

enter the formula
=MOD(ROW(),2)=0
and select what color you want to highlight from the patterns tab.

good luck

On 2002-02-27 07:25, Anonymous wrote:
I have a spreadsheet of about 500 rows and additional rows are inserted every now and then. To make it easier to read when printed off, I want to shade alternate rows. Any idea how to do this - except manually?

Thanks, Lisa (UK)

 

[Guest]

IML

Thanks very much. It worked!

Lisa (UK)