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 ?

Conditional Formating
 

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

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

--
Jacob


"Rob" wrote:

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 ?

Conditional Formating
 

Thank you, works brilliantly

"Jacob Skaria" wrote:

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

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

--
Jacob


"Rob" wrote:

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 ?

Conditional Formating
 

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

--
Jacob


"Rob" wrote:

Thank you, works brilliantly

"Jacob Skaria" wrote:

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

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

--
Jacob


"Rob" wrote:

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 ?