Conditional formatting

[vttech]

I am trying to use Conditional formatting to turn a cell A5 ready in the current date equal a date in Cell A3. I tried =if(today() = A3) in the formula is.

But no luck; any ideas?


Newbie in search of knowledge

 

[AnotherHiggins]

->I am trying to use Conditional formatting to turn a cell A5 ready in the current date equal a date in Cell A3

Sorry, but could you rephrase that? I don't understand what you're asking at all.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[yogia]

I am trying to use Conditional formatting to turn a cell A5 ready in the current date equal a date in Cell A3. I tried =if(today() = A3) in the formula is.

But no luck; any ideas?

Newbie in search of knowledge

Hi vttech:

So what should happen to cell A5? ... meaning how should its formatting change if cell A3 = TODAY()


Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[vttech]

I figure it out I was using the wrong syntax.
It should have been =TODAY()=A3

then the conditional formatting will turn the cell A5 background to red

Newbie in search of knowledge