Glad that you got it but in that case the thanbks go to David.

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rachel" wrote in message
...
Got It!!!! I used =TODAY()-(365*1.5) formula and I was able to get them
all
the change the correct color just change 1.5 to .5 and 0...THANKS SO MUCH!

"Sandy Mann" wrote:

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Cell Value is/ Less than: =TODAY()-(365*1.5)

Very minor point but (365*1.5) is 547.5 so the colour would change during
the day. Perhaps:

=DATE(YEAR(TODAY())-1,MONTH(TODAY())-6,DAY(TODAY()))

or INT(365*1.5)

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Format/ Conditional Formatting:
Cell Value is/ Less than: =TODAY()-(365*1.5) or
Formula is: =DATEDIF(A1,TODAY(),"m")=18

Choose your font colour.
--
David Biddulph

"Rachel" <Rachel @discussions.microsoft.com wrote in message
...
How do I automatically get the font color to change if I have a date
that
is
over 18 months old.....like I have February 1 2006 I want that to
change
to
Red because it is over 18 months old.

Thanks