CF

[Anthony]

I'm attempting to format an entire row based off the data
in a cell on that row, the data is a date. Example:

F7 is "20-Aug-98"; G7 is "Feb 2003" --- G7 = 4years and 6
months out from F7 {=date(year(f7)+4,month(f7)+6,day(f7}.
I'm hoping to format the entire row (12 cells)when G7 is
within (between) 180 days from today()+1. As the date get
closer the row(s) will change colors. Red= >TODAY(),
yellow= 6months out; Green= 90 days out. I hope you get
the idea. Thanks in advance.

 

[Bob Phillips]

Anthony,

Use conditional formatting.

Select the whole row.

For condition1, change to IsFormula, and set the formula to
=$G7>=TODAY()+180
Select the format button, pattern tab, and select the yellow

Condition2, similar technique, formula of
=$G7>=TODAY()+90
colour green

Condition3, similar technique, formula of
=$G7>=TODAY()
colour red