This error message apears in my spreadsheet alot.

#N/A

I would like to do a conditional format, so that if a cell equals #N/A then
it will grey out the font.

i have tried A1="#N/A" in conditional format but it did not work.

any clues?

Instead of 'cell value is' #N/A, use 'formula is' =isna(A1) (or whatever
cell you're testing; as long as you use a relative reference for the cell,
you can copy/paste the format to apply the test to multiple cells).

"ellebelle" wrote:

This error message apears in my spreadsheet alot.

#N/A

I would like to do a conditional format, so that if a cell equals #N/A then
it will grey out the font.

i have tried A1="#N/A" in conditional format but it did not work.

any clues?