Thanks again - this is still not working continues to give me a highlighted
cell for dates in I3 that are 2010 and 2013 does highlighted some that are
dated between today and 60 days plus but not all - sorry to be awkward!
--
Thanks

Lise


"Max" wrote:

With A3 as the active cell,
try these as the CF's "Formula Is"
Condition 1: =AND(ISNUMBER(I3),I3-TODAY()<=60)
Condition 2: =AND(ISNUMBER(I3),I3-TODAY()60)
Format to taste.

Note that you should avoid overlapping conditions. When you craft it up, be
careful with the limits and the use of operators, eg: "<=" and "" in the
above
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Lise" wrote:
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?