Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Programmatic access to visual basic project via Visual FoxPro | Excel Programming | |||
Make visual basic truely visual! | Excel Programming | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |