| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
working with #N/A and conditional formating
Craig,
Use this CF formula =ISNA($A1) Mike "Craig860" wrote: I'm trying to get the row highlighted with a cell value is #N/A #N/A is the result of having NO MATCH on a VLookup table. I've tried different variations in my format and it doesn't seem to recognize #N/A as a value. for example if cell a1=bob then the row is not highlited. if it's #N/A then highlight it because it needs to be addressed. Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| working with graphics and formating them | Excel Discussion (Misc queries) | |||
| Conditional Formating working when data is entered later | Excel Worksheet Functions | |||
| Conditional Formating - formula not working | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
Hybrid Mode
