iferror Conditional Formatting

[Badnames]

I am trying to set a conditional format on a cell so that if the cell shows a "#div/0!" or a value error the text will then display. Anyone know how this can be done?

 

[T. Valko]

I am trying to set a conditional format on a cell so that if the cell shows a "#div/0!" or a value error the text will then display. Anyone know how this can be done?

What text?

Not clear!

 

[Badnames]

My mistake, should have articulated that a bit better. I want the text in B2 to be displayed in the format I setup if cell g20 is displaying "#div/o!" or "#value!", otherwise I'd like b2 to be blank.

 

[T. Valko]

My mistake, should have articulated that a bit better. I want B2 to display "asdasdasdasd" if cell g20 is displaying "#div/o!" or "#value!".

Try this...

=IF(ISERROR(G20),"asdasdasdasd","")

Note that will trap ALL errors not just #DIV/0! or #VALUE!.

If you only want to limit the test to the specific errors #DIV/0! or #VALUE! post back.