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