30, 60, 90 days and past

[Dbfire]

Hello all, in a bit of a pickle. I need the column "UGT Due Date" to turn yellow when 30-90 days closing in on it. then on the 91st day and past or when we get to it to turn Red. Any time before that Green. I know that all in this particular example would be red since the date is past or coming in. Please assist. Thank you for your time.

Start Date	EOC/10-Day/Practical	Days Enrolled	UGT Due Date
3/1/2021	Practical Scheduled	267	1-Sep-21
4/21/2021	CDC Started	216	26-Nov-21
7/21/2021	EOC Taken	125	26-Nov-21
8/4/2021	Practical Scheduled	111	1-Sep-21
10/21/2021	CDC Started	33	26-Nov-21

 

[Fluff]

Hi & welcome to MrExcel.
Is this what you want.

+Fluff 1.xlsm
	A	B	C	D
1	Start Date	EOC/10-Day/Practical	Days Enrolled	UGT Due Date
2	01/03/2021	Practical Scheduled	267	01-Sep-21
3	21/04/2021	CDC Started	216	26-Nov-21
4	21/07/2021	EOC Taken	125	26-Nov-21
5	04/08/2021	Practical Scheduled	111	01-Feb-22
6	21/10/2021	CDC Started	33	26-Mar-22
7
8
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D12	Expression	=AND(D2<>"",D2<=TODAY()+60)	text	NO
D2:D12	Expression	=AND(D2<>"",D2<=TODAY()+90)	text	NO

 

[Dbfire]

Thank you! This is what I was looking for. How would I get the Green conditional by chance? Thank you again for your time!

 

[Fluff]

If you want everything that isn't red or yellow to be green, I'd just put a green fill on those cells.