S
SamuelT
Hi all,
I've got a VLOOKUP list that, if nothing is in the a cell it is lookin
up in returns a "#N/A" cell value. No problem there. However, I'd lik
to hide these values, and just keep the returned VLOOKUP values.
I thought this would be done easiest using conditional formatting o
the cells, and setting the font colour to white if the cell value wa
"#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 i
inverted commas, and also typing #N/A in a cell (let's say A50) an
doing:
Cell Value / equal to / $A$50
Still no joy. Can anyone suggest a means of hiding my #N/As?
TIA,
Samuel
I've got a VLOOKUP list that, if nothing is in the a cell it is lookin
up in returns a "#N/A" cell value. No problem there. However, I'd lik
to hide these values, and just keep the returned VLOOKUP values.
I thought this would be done easiest using conditional formatting o
the cells, and setting the font colour to white if the cell value wa
"#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 i
inverted commas, and also typing #N/A in a cell (let's say A50) an
doing:
Cell Value / equal to / $A$50
Still no joy. Can anyone suggest a means of hiding my #N/As?
TIA,
Samuel