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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"lau" wrote:

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.