Conditional Formatting #n/a

[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?

[jamescox]

The #N/A isn't a text, it's an error value.

Use the IsError() function in your conditional format (where the cell
whose value you are testing goes inside the parentheses) and it should
work.

--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=113078

[Luke M]

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()
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

[Bernard Liengme]

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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Supe" <Su...@discussions.microsoft.com> wrote in message
news:E0782A89-26FA-4538...@microsoft.com...