|
|
#2
09-06-2013, 09:51 AM
|
|||
|
|||
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode