and just a throwaway.. if you want to evaluate column B of each row
individually, get rid of the $2 and instead use $B2. Otherwise, when you
copy the format down the rest of your rows, you'll still be evaluating B2...

"Gord Dibben" wrote:

FormatCFCondition1Formula is:

=$B$2-NOW()=30

Add Condition2 and 3

But you have a couple of conflicts with the <= and =

Who do you want to win if the value is 30


Gord Dibben MS Excel MVP

On Sun, 30 Aug 2009 20:52:01 -0700, 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?