Conditional Formatting #n/a

  • Thread starter Thread starter Supe
  • Start date Start date
S

Supe

I had a spreadsheet sent to me that has the text #n/a in some of the cells.
Want to to a conditional formatting to highlight any cell that contains the
text #n/a but it is not working. Does anyone know why?
 
It's most likely the NA error, as opposed to just n/a. Try changing your
conditional formula to something similar to this:
=A1=NA()
 
As a follow up to the reply by jamescox, you could use a formula such as
=ISNA(A1) in your conditional formatting.

Note when you type =NA() into a cell, what you see is #N/A but as jamescox
points out this is not text but an error value
best wishes
 
Back
Top