| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
Thank You, Thank You...a kingdom of Thank Yous
-- Guenzak "Rowan" wrote: Sorry, that's my mistake. Formula should read: =NOT(ISNA(VLOOKUP(A1,Red,1,0))) Regards Rowan Guenzak wrote: Rowan, That formula is real close but isn't quite working correctly. I tried it and in my table i put about 10 city abbr. Then in my named range I type "HOU" but for some reason after I did that the cells with "hou" turn red as was supposed to happen but so did the cells with "WAS", and "PIT". If I put in "DAL" into my named range the cells in my table with "DAL" turn red but so do the cells with "WAS", "PIT", and "DEN". So for some reason it is formatting the correct cells but also identifying others as needing formatting. Formula probably just needs a small correction but this formula is above my skill level. Please Help.....and Thanks!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
| Conditional Formating & Rand() function | Excel Discussion (Misc queries) | |||
| conditional formating | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
