Conditional Formats Date Based

  • Thread starter Thread starter lau
  • Start date Start date
L

lau

I need to format a row in a workbook so that the cells in the range change
color based on a date on another workbook. It needs to be formatted so that
when a certain date ie 12/1/09 is reached, the color changes to green, but is
yellow or red if it's later than 12/1/09 like 3/1/09 depending on what's
entered in the worksheet.
 
It's best to assign a cell outside your print area to equal the date in the
other workbook, then give that cell a name (like "EffectiveDate"). Then in
your conditional format you can use <EffectiveDate or <=EffectiveDate.
 
Back
Top