|
|
#3
01-05-2015, 12:26 PM
|
|||
|
|||
Here's a start. I made two examples. The one on the left uses the rules you stated literally. In such cases, if someone enters a rectification date that is earlier than the date the snag was logged, the row is not highlighted at all.
The one on the right highlights such rows as complete but also highlights that there is a logical error in the dates. Let me know if this helps or if you need help understanding the conditional formatting equations. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |
| Conditional Formatting | teza2k06 | Excel | 3 | 01-19-2014 02:34 AM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode