Conditional Formatting

**Golly Green** · 01-09-2012, 12:26 PM

I would like to use the conditional formatting task to be able to highlight the attached spreadsheet, such that the entire row (from col A to H) is highlighted predicated on the following conditions: 1) Highlight the entire row (from col A to H) in red if date is = today, 2) Highlight the entire row (from col A to H) in green if the date is tomorrow, 3) The formula that would highlight the entire row(s) (from col A to H) in yellow that are yet to come within the same week as today's date. As of now, I can only highlight the date cell, not the entire row.

**NBVC** · 01-09-2012, 12:36 PM

Revise each condition choosing to: use a formula to determine which cells to format.. then

Red: =$D2=TODAY()
Green: =$D2=TODAY()+1
Yellow: =AND($D2<TODAY()+14,WEEKNUM($D2)=WEEKNUM(TODAY())+1)

**Golly Green** · 01-09-2012, 03:14 PM

NBVC:

Thanks for the feed back. Everything is perfect except for the yellow conditional (remainder of the current week). Using the supplied spreadsheet, let us assume that today were Monday, 2/6/2012. Then the entry on row 10 should be green (which is true based on what you gave me), BUT rows 11 & 12 (2/9/2012 & 2/10/2012) should be yellow - NOT the following week (rows 13 & 14). In other words, the yellow shade should highlight any row that is between the today date, and the upcoming Saturday of that same week - Not the following week.

The full colored rows is exactly what I want for all three situations. Thanks