cell shading

[Guest]

the formula to shade every other cell in a spreadsheet doesn't work for me.
i select the worksheet and type in the following formula, but nothing
happens. any suggestions?
=MOD(ROW(),2)=0

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.CF.html£rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

Sorry should be

http://www.xldynamic.com/source/xld.CF.html#rows

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Will shade every other ROW

 

[Gord Dibben]

The formula has to go into the Formula Is: dialog in Format>Conditional
Formatting.

Sounds like you just entered it in a cell.


Gord Dibben MS Excel MVP