|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
(Excel 2007) Need help with colour change when condition met in drop down list
Hi all, first post here your help is highly appreciated.
I Have Vba drop down list with 9 words and you can choose multiple choices. What i want to do is for each word chosen to change the colour of the whole row. I have tried many ways but its not working with me. The code below I use for multiple choices. PHP Code:
|
#2
|
||||
|
||||
You should be able to do that using conditional formatting alone, without resorting to code.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to import list from Excel into drop-down list into word | ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
Drop down menus colour formatting - Newbie question | TerryStevenson | Word | 2 | 09-17-2013 10:43 AM |
Change cell color when selection is made from a drop down list | fedcco | Excel | 12 | 08-28-2012 10:43 PM |
drop down list from external data source Excel 2007? | Intruder | Excel | 1 | 08-03-2012 05:41 AM |
Ecel 2007 Condition Formatting | Corca | Excel | 0 | 02-01-2012 06:55 PM |