Incorporating Cell color fill in an "if" logical function?
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?
|