Showing #N/A in a formula

N

Nekro

I´m using VLook Up and I don´t want to show the result when it is equal
to #N/A, or change it by another value.

I can do it replacing formulas by values, but I wouldn´t like to do
this.

Any ideas?

Thanks a lot!!!!
 
B

Bob Umlas

Select all the culprit cells and use conditional formatting: change "cell
value is" to "formula Is" and, assuming E1 is the active cell, enter:
=ISERROR(E1), then click the format button, Font tab, make the font white.

Bob Umlas
Excel MVP
 
Top