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.