Hi all,

I've got a VLOOKUP list that, if nothing is in the a cell it is looking up in returns a "#N/A" cell value. No problem there. However, I'd like to hide these values, and just keep the returned VLOOKUP values.

I thought this would be done easiest using conditional formatting on the cells, and setting the font colour to white if the cell value was "#N/A". I tried the following condition:

Cell Value / equal to / #N/A

But Excel doesn't seem to like this. I've also tried the #N/A in inverted commas, and also typing #N/A in a cell (let's say A50) and doing:

Cell Value / equal to / $A$50

Still no joy. Can anyone suggest a means of hiding my #N/As?

TIA,

SamuelT