View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Conditional Formating

I have a cell with a formula in it, this cell displays #NUM! as it answer. I
want to be able to set the format using conditional formating so that this
answer causes the background and the text to turn "White" i.e it appears as a
blank cell. I already have three rules set up 0, =0, <0 that change the
colours, these work fine. but
I can't get rid of the #NUM!

Can anyone help ?