Row Color based on cell entry

My problem consists of integrating data from two locations. In worksheet One
I have collected about 500 rows of data over 14 columns. Column C houses
client names and thus acts as a unique identifier. The rest of the columns
consists of address, financial data, etc.... Worksheet Two includes a drop
down list that the manager can look up a particular client (based on
Worksheet One) which then populates other fields for the sole purpose of
sending out a nicely layed out invoice. I would like worksheet one to color
code the row based upon matching client names which can change often in
worksheet two. I do not want to use conditional formatting as this tends to
slow down the application. Any suggestions on VBA?

Do you have a list of the company names to use as a "search" type situation? If so, a column can be made with the color code number in it next to the company name. Then a basic search function would link each name on the first sheet back to the color coding on the 2nd sheet. I can write the code if you have some more info to share as far as what your needing, number of names, etc

My initial thought was for the entire row to turn yellow if the condition is
meet. Specifically if I go to Worksheet Two and at cell C4 highlight the
drop down menu and choose, for instance, ABC Company, then the VBA would
recognize this choice, go to Worksheet One and highlight row 4 because this
is what row ABC Company's data is located (the name specifically in column
C).
This would change each time the user pulls down a different company name in
the dropdown menu in Worksheet Two. Is this doable?

"dok112" wrote:

>
> Do you have a list of the company names to use as a "search" type
> situation? If so, a column can be made with the color code number in
> it next to the company name. Then a basic search function would link
> each name on the first sheet back to the color coding on the 2nd sheet.
> I can write the code if you have some more info to share as far as what
> your needing, number of names, etc
>
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=513852
>
>

Yes it is. How do you have the drop down coded on the 2nd sheet? Is it a in-line drop down or a combobox from vba?

I created this through the Data Validation menu. I guess it is an in-line
drop down as I did not write in VBA.

"dok112" wrote:

>
> Yes it is. How do you have the drop down coded on the 2nd sheet? Is it
> a in-line drop down or a combobox from vba?
>
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=513852
>
>

how many companies are there in the drop down?

Currently 65 but this will grow as the department grows. My potential color
range is C4: X65.

"dok112" wrote:

>
> how many companies are there in the drop down?
>
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=513852
>
>

Is there just 1 drop down menu for the names of the companies? or are there multiple? If it's just one, it might be easier, code-wise to use a combobox from the VBA toolbar there.

Just one drop down box that was created from the Excel menu (Data,
Validation). I hope that this helps.

"dok112" wrote:

>
> Is there just 1 drop down menu for the names of the companies? or are
> there multiple? If it's just one, it might be easier, code-wise to use
> a combobox from the VBA toolbar there.
>
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=513852
>
>

This is what I have come up with. Is this what you are looking for? If not, let me know...It's real basic, and there would need to be more info, but thats just the concept of the programming.

I'm having a bit of trouble downloading from work. I will try from home
later today. I will post reply on Tuesday for continuation. Thanks.

"dok112" wrote:

>
> This is what I have come up with. Is this what you are looking for? If
> not, let me know...It's real basic, and there would need to be more
> info, but thats just the concept of the programming.
>
>
> +-------------------------------------------------------------------+
> |Filename: Book1.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4373 |
> +-------------------------------------------------------------------+
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=513852
>
>

Can you post this code to a reply? I am having some trouble accessing. TY

"dok112" wrote:

>
> This is what I have come up with. Is this what you are looking for? If
> not, let me know...It's real basic, and there would need to be more
> info, but thats just the concept of the programming.
>
>
> +-------------------------------------------------------------------+
> |Filename: Book1.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4373 |
> +-------------------------------------------------------------------+
>
> --
> dok112
> ------------------------------------------------------------------------
> dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
> View this thread: http://www.excelforum.com/showthread...hreadid=513852
>
>