|
|
#2
03-24-2012, 08:16 PM
|
|||
|
|||
Hi WRighty50
I'd try making your CF formula a little different. You have =ISERROR(MATCH(B2,INDIRECT(SUBSTITUTE(A2," ","")),FALSE)) and I'd try =ISERROR(MATCH($B2,INDIRECT(SUBSTITUTE($A2," ","")),FALSE)) BTW - Column 3 didn't turn red on your attached. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
 Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
|
Conditional Formatting
|
namedujour | Excel | 3 | 08-25-2011 01:46 PM |
| Conditional Formatting Problem Excel 2007 | namedujour | Excel | 6 | 08-04-2011 10:52 AM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode