| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| Changing the color of a list entry based on a tolerance | Excel Worksheet Functions | |||
| Changing a cell color based on date entry ... | Excel Programming | |||
Linear Mode
