I don't think this will work for what I am trying to do. Is there a way to
post a picture so I can show a screen shot of what I am trying to explain??

"Don Guillett" wrote:

You can just use conditional formatting
formatconditional formatformula istype in something like thisformat as
desired.
=IF(MATCH(F7,$A$7:$C$7),TRUE)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gatech steph" <gatech wrote in message
...
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.