|
|
#7
03-25-2012, 07:50 AM
|
|||
|
|||
Hi wrighty50,
Pecoflyer didn't like the "False" because the MATCH() function is looking for a -1,0 or 1 for the third argument. Your "False" in your CF formula will translate to a zero and all if fine for an exact match. So you can use a zero or False in your case. I'll look at your new attach file now but wanted to get the False vs Zero partial question answered first. 
|
|
|
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