Conditional Formatting

[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

 

[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 (e-mail address removed), "picktr