Conditional formatting with date range

[Rock5150]

Hello all,

I have a spreadsheet where i need to color code the Date Uploaded cells with either green, yellow, or red. Green are documents uploaded 1-14 days post-approval (column A), yellow is 15-21 days post-approval, red is 22+ days post approval. I'm struggling trying to get the today date to format correctly with the date uploaded. for example the first two rows show "red" however these should be "green

Book1
	B
7
Sheet1

This is a coworker's spreadsheet and the formula for C2 for conditional format is =AND(IF(ISBLANK(A2)=FALSE,B2<>"YES"),A2<TODAY()-30

 

[Rock5150]

See below reply

 

[Rock5150]

Book1
	A	B	C
1	Final Approval Date	Uploaded to PDMS	Date Uploaded
2	1/8/2021	Yes	1/21/2021
3	2/8/2021	Yes	2/19/2021
4	12/9/2020	Yes	3/2/2021
5	3/29/2021	Yes	4/7/2021
6	3/17/2021	Yes	4/1/2021
Sheet1

 

[Rock5150]

Follow up: The color formatting needs to be in column C