If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formats Date Based
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. |
#2
|
|||
|
|||
Conditional Formats Date Based
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. |
Thread Tools | |
Display Modes | |
|
|