Thread: #N/A values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default #N/A values

You can use conditional formatting to make the font white (or whatever the
background colour of the cell is).
--
David Biddulph

"Trivikram" <vichram at the rate of yahoo dot com wrote in message
...
Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
result of a funtion or formula) values in an excel sheet?

Trivikram.