Try it with a formula

=AND(A1=A2,A1=A3)


--
HTH,
Barb Reinhardt



"Mac" wrote:

Hello,

in Excel 2003, how do I make the following:

if the number in cell in Column 1 is found in Column 2 AND in Column 3, do
some formatting... The point is - I know how to make the conditions, but how
do I impose the 'AND' paradigm between both? That is - do the formatting only
if both conditions hold true...aren't the conditions OR'd by default? Thanks!