Page 172 - Excel Timesaving Techniques for Dummies

32_574272 ch28.qxd 10/1/04 10:49 PM Page 157
157
Trapping All Types of Error Values
If you want to be alerted when a formula con-
tains an error value even as you suppress its
display with an error-trapping formula, apply
some type of conditional formatting to its cell.
To do this in cell B9 of the example work-
sheet template, you would set up a Formula
Is ISERROR($N$7) Condition 1 and then
assign some sort of bold font and background
color formatting to signify when the condition
is TRUE. (See Technique 19.)
• Figure 28-4: Worksheet template after modifying the
original IF formula to trap all error values.