Thanks. I had misinterpreted that "A1" meant that I entered all cell
references, not just "A1".

"David Biddulph" wrote:

It will work happily for the whole sheet.
Formula is =ISNA(A1)
--
David Biddulph

"Leo" wrote in message
...
Hi all,
I was trying to do the same thing, but wanted to apply this to the whole
spreadsheet with conditional formatting. It works for individual cells,
but
will not work for multiple cells.

"JD2" wrote:

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