Drop down list of numbers returning colours

[michaelvw]

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.

[C J Squibb]

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!