Thread: Conditionally formatting cells with "#N/A" as value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Conditionally formatting cells with "#N/A" as value
There is a distinction between the text string "#N/A" and the error code
NA()
--
David Biddulph

"Jen O.P." wrote in message
...
I want all cells with a value of "#N/A" to show up as shaded and I can't
get
any result. I am using cell value is equal to "#N/A" and nothing!
I am using Excel 2003.


Reply With QuoteReply With Quote