Change cell color when selection is made from a drop down list
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.
|