#N/A conditional format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
Back
Top