Change cell color when selection is made from a drop down list

fedcco · #1 08-21-2012, 12:11 PM

I’ve made an excel 2007 spreadsheet with some data validation drop down lists. I want to be able to, (either with VB code or the like) have the target cells and the fonts, change in color when a selection from the drop down list in Col. V is made. Below is a list of the drop down which is between cells V3:V18 of my spreadsheet. I want to be able to choose any cell in the range of D3-D350 and have that cells color change to the corresponding selection.

For example, if I choose "Blue" for cell D17, then that cell should change to Blue and font to white. If I choose cell D25 and select " PEDS CODE BLUE " again, the cell should turn Light Blue, font Black and so on.

Cell Selection Indx Clr Font Clr
V3 BLACK 1 2
V4 BLUE 5 2
V5 CADIAC ALERT 30 2
V6 GREEN 4 1
V7 GREY 16 1
V8 ICE ALERT 37 1
V9 ORANGE 46 1
V10 PEDS CODE BLUE 8 1
V11 PINK 7 2
V12 PURPLE 13 2
V13 RAPID RESPONSE 20 1
V14 RED 3 2
V15 STEMI ALERT 53 2
V16 STROKE ALERT 22 1
V17 WHITE 2 1
V18 YELLOW 6 1

The target cells are from D3-D350. Attachment Included.

Any help would be extremely appreciated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro ? - Checkbox in Word + drop down selection help	dice1976	Word	4	07-24-2012 11:18 AM
Change cell color everytime a value is selected in dropdown list	angelica_gloria	Excel	4	01-27-2012 06:47 PM
Made a mistake with a macro change	lance_kidd	Word	0	02-09-2011 06:36 PM
Ho to perform multi selection in drop down lists?	nashville	Word	0	09-29-2010 07:10 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM