I did this and changed the colors but they all changed red

"Sandy Mann" wrote:

You can have three levels of Conditional formatting. Use the same formula
with different = values and colours

--
HTH

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
...
Thank you Sandy...that worked...I just realized though I need to color
code
different if its over 6 months as well as under can that be added to the
formula to?

example

Feb 1, 2006 over 18months needs to be Red
May 06 over six months needs to be blue
anything under 6 months needs to be green

Thanks

"Sandy Mann" wrote:

Format Conditional Formatting select Formula Is form the dropdown and
enter:

=DATEDIF($G$4,TODAY(),"m")=18

Change the $G$4 to your own reference

--
HTH

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


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


"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