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