Conditional Formatting Question (Hiding "#N/A" err

[Excel Bunny]

Hello All,

This board has been so helpful in the past so I thought I would try my luck once again.

I am working on a table that drags data from other worksheets using VLOOKUP so sometimes fields in this table show up "#N/A" errors (these are instances when the lookup value cannot be found in the source file).

What I want to do is set Conditional Formatting to display all "#N/A" errors as white text, hence rendering them invisible. I assume a formula will be required but I'm not sure which one. Any ideas on this matter would be much appreciated.

Thank you to the regular posters for providing solutions to a variety of Excel dilemmas - I have learnt much just by scanning through past entries. Cheers.

 

[Peter_SSs]

Peter, your solution to get rid of N/A errors altogether is absolute gold and will come in very handy from now on.

Just keep in mind that it is sometimes useful to see the errors because they may highlight something else in your sheet that needs attention. So hide with caution.

 

[Excel Ranger]

I just started using the VLOOKUP function. Under Conditional formatting, 'formula is' '=ISERROR(A1:AH24)' font color white. This will also 'hide' that pesky #N/A error message. If you want to get rid of that little green upper left corner eror flag, then TOOLS - OPTIONS - ERROR CHECKING - ENABLE BACKGROUND ERROR CHECKING (clear the checkmark). This will hide the green markers.