software

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=quot;#N/Aquot; 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).

quot;ellebellequot; wrote:

gt; This error message apears in my spreadsheet alot.
gt;
gt; #N/A
gt;
gt; I would like to do a conditional format, so that if a cell equals #N/A then
gt; it will grey out the font.
gt;
gt; i have tried A1=quot;#N/Aquot; in conditional format but it did not work.
gt;
gt; any clues?