Can I conditional Format #N/A

[dandavis1]

I have a number of cells with this type of formula in it -

=IF('Sheet1'!B83="",NA())

can i conditional format these cells so that #N/A can be a different colour, I have tried a number of options and although when I click OK after entering the conditional format I do not get an error, but the #N/A has not changed colour.

ANy tips? Cheers!!!

[JeanRage]

Hi,

Have you tried ...:

IsError()

HTH

[arthurbr]

Maybe using the following as consition for your formatting =isna(your_cell)

[daddylonglegs]

Note: you posted this question twice - possibly unintentionally. I deleted the other thread

[dandavis1]

thanks alot arthurbr, that has workd!!