Conditional Formatting

P

picktr

Is there any way, under conditional formatting,
to turn the cell a different color, when an
ERROR is returned in that cell?

i.e. #NUM! or ######

I know how to change the color
 
D

Domenic

Try,

Format > Conditional Formatting > Formula Is:

=ISERROR(A1)

I'm not sure about your second example ---> ######. Although, I suspect it
may be the result of the column not being wide enough to accommodate a date.

On 5/12/04 11:07 AM, in article [email protected], "picktr
 
Top