Cell Background Color

  • Thread starter Thread starter Pete
  • Start date Start date
P

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
 
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
 
Back
Top