Thread
:
Hiding #N/A error (or displaying a blank cell instead of #N/A)
View Single Post
#
13
Posted to microsoft.public.excel.newusers
Dave Curtis
external usenet poster
Posts: 100
Hiding #N/A error (or displaying a blank cell instead of #N/A)
Hi,
An alternative to all this, if you just want to hide the #N/A is to use
conditional formatting to change the text colour to match your background
colour if the cell contains #N/A.
Dave
url:
http://www.ureader.com/msg/10356562.aspx
Reply With Quote
Dave Curtis
View Public Profile
Find all posts by Dave Curtis