View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Conditional number format in Excel 2007

I have an array of data where I don't want errors to display. I tried using
a conditional format where I would set the number format to ";;;"
(non-displayed) if ISERROR(cell ref) is TRUE. The errors still displayed.
Can anyone help me with this? (I cannot simply change the font color to
equal the background color, because the background color itself depends on
another conditional format.)