Use Conditional Formatting, not worksheet functions.

Which column is your date in?

Do you want all the cells on a particular row to change colour, or
just the date column?

Pete

On Jan 16, 1:50*pm, Melissa44
wrote:
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)