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?