Conditional formatting error codes

[maxpi]

How can I formulate the expression in a conditional format to recognize error codes? I want cells with #DIV/0!, #VALUE!,etc. to be the same as the background.

Max

 

[lenze]

Formula is
=ISERROR(A1)

 

[maxpi]

I don't quite see how I can use that formula to affect the conditional formatting in the cell with the error.

Max

 

[lenze]

Say the cells you want to format are A1:H20. Select this range and choose conditional formatting. Select the Formula is option. Enter =ISERROR(A1). Excel will adjust the formula for all the other cells in the range. Now, when a cell in this range contains an error, the conditioanl formatting will be applied.

HTH
This message was edited by lenze on 2002-10-22 15:42

 

[maxpi]

Thanks muchly, worked like a charm.

Max