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