cell shading
 

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

cell shading
 

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)

"GUH" wrote in message
...
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

cell shading
 

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)

"GUH" wrote in message
...
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

cell shading
 

Will shade every other ROW
--
Gary''s Student - gsnu200738


"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

cell shading
 

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