To copy the format down for other rows, change to
=IF(MATCH(F7,$A7:$C7),TRUE)
Send your workbook to my address below if you like along with clear
explanations of what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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