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)


"krupesh" wrote in message
ups.com...
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