View Single Post
 
Old 09-06-2013, 09:51 AM
C J Squibb C J Squibb is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Aug 2013
Location: Essex
Posts: 14
C J Squibb is on a distinguished road
Default

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!
Attached Files
File Type: xlsx CS Colour Quadrants.xlsx (9.0 KB, 11 views)
Reply With Quote