#1
|
|||
|
|||
Ecel 2007 Condition Formatting
Hi,
I'm going crazy!! Help appreciated. ......A.......B 1 1201 Done 2 1201 Done 3 1202 Done 4 1203 5 1204 6 1204 Done 7 1204 Done 8 1204 Require condition in Column B for each Row (Example below for Cell B4): 1) Is B4 Blank (True) 2) Is B4<A4 (True) 4) Is B4="Done" (False) 5) Is B4=A4 (False) If points 1 to 5 are in play then colour change to red. If any points are not in play then colour not to change. rgds, Corca!!! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge - Filters adding condition not originally specified | bobcharest | Mail Merge | 11 | 06-13-2014 11:03 PM |
Word 2007 doc formatting XP vs Win 7 | rluna68 | Word | 4 | 10-11-2011 12:07 PM |
check with condition | karti | Word | 2 | 03-15-2011 06:06 AM |
Formula in a Cell with condition? | Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
Retrict Method Condition | markp | Outlook | 0 | 12-22-2005 05:38 PM |