Conditional Formatting of #n/a result

[sstook]

I am using a vlookup function which, when it returns the
#n/a result I would like to format conditionally, i.e. if
it is #n/a, blank out the cell. How would I do this?

 

[Debra Dalgleish]

There are instructions here for hiding all errors, or only #N/A errors:

http://www.contextures.com/xlCondFormat03.html#Errors

 

[BrianB]

No need to blank anything out. Just add to your formula to get something
like this (copy from here and paste into your formula bar) :-

=IF(ISERROR(VLOOKUP(A1,$B$10:$C$100,2,FALSE)),0,VLOOKUP(A1,$B$10:$C$100,2,FALSE))