Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating Based on Formats Instead of Values | Excel Discussion (Misc queries) | |||
Conditional Formating based on Date | Excel Worksheet Functions | |||
conditional formats based on If | Excel Worksheet Functions | |||
Conditional Formating Based on Date | Excel Discussion (Misc queries) | |||
Copy Color Formats Based On Column Date Values | Excel Discussion (Misc queries) |