Conditional Formatting of #N/A Result

[Josue Barocio]

I want to highlight all the #N/A results of a Vlookup function in a column. Conditional Formatting refuses to recognize #N/A, evidently because of the pound sign.

Is there a way to get around this?

Thanks

 

[Aladin Akyurek]

Use:

=ISNA(CellRef)

 

[jimbojones]

Maybe use an if statement in the formula which is creating the #N/A to get a better result. For example where your #N/A formula = FORMULA:

=if(iserror(FORMULA),"Error",FORMULA)

Failing this can't you use an If(iserror(CELL) in the Conditional formatting????

Jim

 

[Josue Barocio]

Hot dog! It took you all of two minutes. It works just fine. Thanks Aladin, you guys are great.