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