View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Highlight cell on certain dates

First one should be
=I3=""
Excel puts extra " when you fist defirne it. Go back and remove the extra
quotes
othes are Ok... it is better if you Put () around today()- 60 to be clear

You may put the conditions in any cell first to see that they work... you
are Ok if you get TRUE...

You are applying the condition to A3, right?

"Lise" wrote:

Hi

Wanting to highlight A3 if I3 is within 60 days from todays date - I have
read a couple of pointers that led me to write the following for three
conditional formats

1. =I3="""" Outcome wanted Blank Cell
2. =I3=Today()-60 Outcome wanted White Background Black Font
3. =I3<=Today()-60 Outcome wanted Red Background Black Font

But they are not working what am I doing wrong please? should I have +'s
somewhere?

Thanks as always
Thanks

Lise