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?

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=51385

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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

Row Color based on cell entry
 

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