Okay I tried that and it didnt work. Or I messed it up somehow.

Here are the example dates I have:
10/17/2008
12/23/2008
11/28/2007
12/10/2008
12/10/2008

So everything in Dec should be green (which I changed my font default to
green), 11/28/07 should turn red. So I highlighted column E because that is
the dates I want to change colors. I made my default color font green. I
click on FormatConditonal Formatting. First my first one, I click the drop
down box and changed "Cell value" to "Formula is". Then I copy and pasted
the formula you said =DATEDIF(A2,TODAY(),"y")=1 and changed the font color
to red. Then I added another Conditions. In Condition 2, I changed the
"Cell value" is to "Formula is" and pasted the second formula you gave me
=DATEDIF(A3,TODAY(),"m")=6 and changed that font to orange. Then I clicked
okay and nothing happened.

In (K1) is where I have the date =Today()? Did I not do something right?





"David Biddulph" wrote:

First CF condition/ Formula Is/ =DATEDIF(A2,TODAY(),"y")=1 for your Red
Second CF condition/ Formula Is/ =DATEDIF(A3,TODAY(),"m")=6 for Orange
Default formatting Green
(and perhaps also test for blank cells if this might be an option).
--
David Biddulph

"Melissa44" wrote in message
...
I have a spreadsheet that list all my recruiter's clients and when the last
time they had lunch with them. I am looking for a way to change the font
color depending on when the last time they had lunch with them. Here is
what
I am looking for.

Year and Over: Red font
6 months to a year: Orange font
current date to 6 months: Green Font

What would be the formulas to get these to change and keep up with the
most
current date (being today)