Conditional Formating

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

 

[Jacob Skaria]

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

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

 

[Rob]

Thank you, works brilliantly

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

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

 

[Jacob Skaria]

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