MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Reversal of Conditional Formatting


Posted by Jean on February 15, 2002 3:51 AM

Here's the problem. I have one column showing dates which are conditionally formatted to change font colour within three days of the current date. Using =D2<=(TODAY()-3)
I now need the cells in this column to change back to their original colour when an entry is made (eg "Y") in another column (say E2)
Can anyone help?


Posted by lenze on February 15, 2002 6:30 AM


Make the condition for columns E=Y the first condition in the conditional formatting. It will supersede the second condition.

Posted by Jean on February 15, 2002 7:06 AM

Posted by lenze on February 15, 2002 8:40 AM

You can use an logical test for your condition as long as it evaluates to either TRUE or FALSE. If a condition is TRUE, the formatting is applied and does not proceed to the next condition. If a condition is FALSE, then the next conditonal test is applied.

HTH : Many thanks - just one other question. What if the cells in the column contained a date rather than "Y"? : Make the condition for columns E=Y the first condition in the conditional formatting. It will supersede the second condition. :

Posted by Jean on February 16, 2002 10:54 AM

Many thanks lenze !

HTH