searching in visual basic
 

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.

searching in visual basic
 

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.

searching in visual basic
 

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.

searching in visual basic
 

To the Original Poster,
Just to add that Match works with a single column or single row. If by 3
columns of data you mean you have multiple rows, Match may not be the best
choice.

--
Regards,
Tom Ogilvy


"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.

searching in visual basic
 

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.

searching in visual basic
 

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.

searching in visual basic
 

Ok that some what worked for what I need but I have some blank cells in
between sets of rows that are being considered as match. Is there a way to
avoid this becuase I do not want these cells to be highlighted.

"Tom Ogilvy" wrote:

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.

searching in visual basic
 

Just check that condition

=if(A1="",False,countif( . . . ))

--
Regards,
Tom Ogilvy



"gatech steph" wrote:

Ok that some what worked for what I need but I have some blank cells in
between sets of rows that are being considered as match. Is there a way to
avoid this becuase I do not want these cells to be highlighted.

"Tom Ogilvy" wrote:

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.