conditional formatting for Error

K

krupesh

Hi Friends
I want to format those Cells which contains any error. I have tried in
conditional formatting with as Formula is =ISERROR, but it is not
working. can any one help on this

Thank you
 
B

Bob Phillips

Select your cells and use the cell referen ce of the first, such as

=ISERROR(A2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top