|
|
#1
08-21-2012, 12:11 PM
|
||||
|
||||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode