Ken

Don't need to use IF

Also NOW is a function and syntax is NOW()


Gord

On Mon, 31 Aug 2009 14:11:52 -0700 (PDT), Ken wrote:

I think the quotation marks around your IF statement are probably
messing you up.

=If(($B$2-NOW)=30)
=if(($B$2-NOW)<0)
=If(($B$2-NOW)<=30)

You will still have the logic issues that Gord pointed out.

Ken

On Aug 30, 11:52*pm, Josh wrote:
I am trying to shade the row if a particular cell in the row has a date value
in one of three categories. What I have done is not working. Statements are
below.

="If(($B$2-NOW)=30)"
="if(($B$2-NOW)<0)"
="If(($B$2-NOW)<=30)"

It is not coloring a single cell.Any ideas of better logic to use?