|
|
#3
06-05-2018, 10:33 PM
|
||||
|
||||
You aren't the first person to want to do this and a google search (with the right terminology) will reveal several approaches.
http://lmgtfy.com/?q=excel+conditional+data+validation This one looks good https://www.excel-university.com/cre...ta-validation/
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dropdown select worksheet to point data? | ShankedS | Excel | 21 | 05-08-2018 11:09 AM |
| Selection of a dropdown creates another dropdown wih the list | krishnamurthy.ka2810 | Word VBA | 1 | 04-26-2018 11:44 PM |
| Looking to copy select cells in table using dropdown list to paste to new table in another worksheet | CaptainRetired | Excel Programming | 18 | 01-04-2018 07:22 PM |
| Have a cell filled black when blank in dropdown list | Aussie_81 | Excel | 14 | 04-06-2017 04:50 AM |
| Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |
Windows 10 
Office 2016
Threaded Mode