Add the first condition of

=AND(A1=B1,B1=C1) and format accordingly, then extra conditions of
=A1=B1, yellow
and
=B1=C1, red

--

HTH

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


"snax500" wrote in message
oups.com...
Thanks but your formula doesn't work if both column A and C are equal.
Any other ideas.