I already have a formula which controls the date in a cell (A2) which depends
on dates in other cells (A3:A7). Now I am trying to make the background of
cell (A2) to be either RED, YELLOW, or GREEN depending on the date in cell
(A8) as follows:

A2 background is RED if the date in A2 is greater than the date in A8; or
A2 background is YELLOW if the date in A2 is 0 to 120 days less than the
date in A8; or
A2 background is GREEN if the date in A2 is more than 120 days less than the
date in A8

Any help apprecited.
Pete

Select cell A2.
On the menu bar, click FormatConditional Formatting
Click the Arrow where it says cell value is amd
select Formula is.

Conditon 1 Formula is: = A2A8
Click FcormatPattern, select Red, Click Add

Condition 2 Formula is: = AND(A2<=A8,A2=(A8-121))
Click FormatPattern, select Yellow, Ckuck Add

Condition 3 Formula is: = A2<(A8-120)
Click FormatPattern, select green
Click OK

"Pete" wrote:

I already have a formula which controls the date in a cell (A2) which depends
on dates in other cells (A3:A7). Now I am trying to make the background of
cell (A2) to be either RED, YELLOW, or GREEN depending on the date in cell
(A8) as follows:

A2 background is RED if the date in A2 is greater than the date in A8; or
A2 background is YELLOW if the date in A2 is 0 to 120 days less than the
date in A8; or
A2 background is GREEN if the date in A2 is more than 120 days less than the
date in A8

Any help apprecited.
Pete