Conditional Formating

R

Rob

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 ?
 
J

Jacob Skaria

Instead of using Conditional formatting to make it display blank...modify the
cell formula as below

=IF(ISERROR(yourcurrentformula),"",yourcurrentformula)
 
R

Rob

Thank you, works brilliantly

Jacob Skaria said:
Instead of using Conditional formatting to make it display blank...modify the
cell formula as below

=IF(ISERROR(yourcurrentformula),"",yourcurrentformula)
 
J

Jacob Skaria

Thanks for the feedback. Incase you are using XL2007 checkout help on
=IFERROR()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top