#1
|
|||
|
|||
Drop down list of numbers returning colours
Hi
I would like to track training progress that is visual. I want 4 cells that make up a 'cube' to be coloured according to what number is selected from a drop down list in the top left cell of the cube. The first cell A1(top left) has a drop list of numbers 0 - 4. When 1 is selected the first cell (A1) is coloured yellow. If 2 is selected, (A1 & A2) are coloured Orange. If 3 is selected, (A1, A2, B2) are coloured Blue and finally if 4 is selected all cells in quadrant are coloured (A1, A2, B1, B2) Green. If 0 is selected, all 4 cells return to a blank state. I used data validation for the list of 0 - 4. This is in cell A1 I do not want the number selected to be visible once it's chosen. I want that to just drive what segments of the quadrant will be coloured. Any help would be appreciated. Last edited by michaelvw; 08-14-2013 at 07:21 PM. Reason: Added file of what's been done |
#2
|
|||
|
|||
I have just come across this question and had a look at your problem - which I expect you have sorted by now. I adjusted the conditional formats so they operate by looking for the value in cell $A$1. And I formatted the text to match the background colour, which makes the contents of cell A1 invisible. Finally, I entered the data validation values directly into the list source (simply "0,1,2,3,4", without the quotes). Tweaked version attached!
|
|
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 |
Returning a specific value when item is selected from a drop-down list | J Press | Excel | 4 | 09-10-2012 06:12 AM |
Drop down list, Can it be done??? | garethreid | Outlook | 0 | 08-09-2012 06:08 AM |
Drop Down List Question | beb1227 | Excel | 6 | 12-08-2011 07:26 PM |
Create Drop Down List Box | hbradshaw | Word VBA | 0 | 09-27-2010 06:24 AM |