Hi Guys!
I have a list box which have brand names and linked to cell "A8" I just need that when I select a brand from list box then in a particular data range which is C41:K61 the specific row which contains the same brand name highlight with some color in range column C to K. for example I have selected brand "Dalda" in last combo box then i need the range C42:K42 be highlighted with any color.
I have attached a picture contains my excel sheet for convenience. any help regarding this in terms of formula or VBA code which can solve my problem will be highly appreciated.
The form is in excel 2003 format.
Thanks in Advance,
Bookmarks