| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - #N/A Errors
Dear Excel Gurus,
I have a workbook containing several VLOOKUP functions. I would like to format cells with a red fill colour if the result for the vlookup is false and a #N/A error message appears to highlight them in the spreadsheet. I've tried both if cell value is #N/A and Formula is =c1=#n/A and various variations, but no luck! Any suggestions? Regards JD2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Threaded Mode
