Conditional Format specific errors

[ExcelNoob222]

Hi,

Is there any way to conditional format specific errors? I know you can conditional format all errors but I'd like to highlight #N/A one colour and #Name? errors another colour.

Thanks!

 

[Joe4]

Note that Excel has an ISNA function (How to use the Excel ISNA function | Exceljet).
So you can use that for that ISNA error check, and for the other one you could use something like:

=AND(ISERROR(A1),ISNA(A1)=False)

to check for an error that is not an ISNA error.

 

[ExcelNoob222]

Note that Excel has an ISNA function (How to use the Excel ISNA function | Exceljet).
So you can use that for that ISNA error check, and for the other one you could use something like:

=AND(ISERROR(A1),ISNA(A1)=False)

to check for an error that is not an ISNA error.

Hi, ya I completely agree or using an iferror() function. Unfortunately, I have inherited this file that has almost 3,000 formulas of which 20% have errors. The original author set it up terribly. So I'd like to try to change th font colour to white for #name? errors as I don't need to review those but change the #N/A to highlight yellow so that I can review them.

 

[Joe4]

I think you misunderstood. I am not talking about updating the formulas on the spreadsheet (and note I used ISERROR, not IFERROR, those are two totally different functions).
I was giving you the formulas to use for your Conditional Formatting rules.

#N/A error Conditional Formatting formula
=ISNA(A1)

All other errors Conditional Formatting formula
=AND(ISERROR(A1),ISNA(A1)=False)

 

[ExcelNoob222]

I think you misunderstood. I am not talking about updating the formulas on the spreadsheet (and note I used ISERROR, not IFERROR, those are two totally different functions).
I was giving you the formulas to use for your Conditional Formatting rules.

#N/A error Conditional Formatting formula
=ISNA(A1)

All other errors Conditional Formatting formula
=AND(ISERROR(A1),ISNA(A1)=False)

You are right, I completely misunderstood. Thank you for clarifying. This worked. Thank you so much!

 

[Joe4]

You are welcome.
Glad I was able to help!