Conditional Formatting using dates

[EX7EY]

Hi all, I am trying to figure out the correct formula to change a cell colour based on how far away I am from a date.

For example, In column G I have due dates, and I would like the corresponding cell from the same row in column A to turn either green Amber or red depending on how close we are to the due date in column G.

So if today's date is within 7 days of the due date in G2, I would like A2 to fill red, within 14 days amber, and over 14 days green. I would like this replicated all the way down the column.

Hopw this makes sense, any help would be much appreciated. Thanks

 

[EX7EY]

**EDIT**

I meant between 7 and 14 days Amber. Not within 14 days

Thanks again

 

[jtakw]

Hi,

3 separate CF Formula rules for Column A:

Book1
	A	B	C	D	E	F	G
1	Within 7 days	8 to 14 days	over 14 days
2	FALSE	TRUE	FALSE				2/19/2019
3	FALSE	FALSE	TRUE				2/28/2019
4	TRUE	FALSE	FALSE				2/10/2019
5
6	for RED	for AMBER	for GREEN
Sheet540

Cell Formulas
Range	Formula
A2	=TODAY()+7>=G2
B2	=G2=MEDIAN(TODAY()+8,TODAY()+14,G2)
C2	=TODAY()+14