Text colour change due to variant

[drsrst2zvh]

Hello im very new to this forum but i have had help here before.
Im looking to make a certain cells text change colour dependant on what date another cell states inside it.
Basics are i want the text to go red if the date has passed, to go amber if the date is within the next 30 days, and be green if the date is more than 30 days in the future?
Is this possible? if so can you tell me how?
Thanks
D

 

[BradleyS]

Use Conditional Formatting!

Follow this link http://www.mrexcel.com/articles/due-dates-with-conditional-formatting.php

 

[drsrst2zvh]

Im using the new verison of excel so that is no use too me also would i need to put anything extra in the text as i want it to use the actual day we are in as the benchmark so 30 days from today would be 29 2moro. does that make sense?

 

[BradleyS]

How about these then using conditional formatting formulas:

Before today
Formula
=AND(A2-TODAY()<0)

Due in the next 30 days:
Formula:
=AND(A2-TODAY()>=0,A2-TODAY()<=30)

More than 30 days:
Formula:
=AND(A2-TODAY()>=0,A2-TODAY()>30)