Use Conditional Formatting found under the format menu (in xl2003 and
earlier).

for the conditional formatting formula
Use countif to determine if there is a match. So this would be the basis:

=countif($AA:$AC,A1)

Look in the conditional formatting sections at Debra Dalgleish's site.

http://www.contextures.com/tiptech.html


--
Regards,
Tom Ogilvy


"gatech steph" wrote:

I am fairly new to writing in visual basic and I need some help. I have 3
columns of data to "side one" of a worksheet and then a seperate 3 columns on
"side two" of the same worksheet. The two sides are simply seperated by a
couple columns. I need to compare the two sides to find matches. I do not
need it to find matches on the same side of data just from one side to the
other. If there are matches I need for the cell to change to an orange
background.