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