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

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