The formula has to go into the Formula Is: dialog in FormatConditional
Formatting.

Sounds like you just entered it in a cell.


Gord Dibben MS Excel MVP

On Mon, 20 Aug 2007 07:26:03 -0700, GUH wrote:

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