Cell Background Color

[Pete]

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

 

[JLGWhiz]

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

Conditon 1 Formula is: = A2>A8
Click Fcormat>Pattern, select Red, Click Add

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

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