View Single Post
 
Old 03-19-2023, 11:03 PM
Jameswalter Jameswalter is offline Windows 11 Office 2016
Novice
 
Join Date: Mar 2023
Posts: 5
Jameswalter is on a distinguished road
Default

Now, in E1 select data validation and in the parameter dialog box select List with the Source as B1:B4. Check in-cell dropdown. Now, in cell E1, clicking the arrow gives you a selection from the four colors, select one. Now click the arrow again and you are presented with the remaining possible selections.
Reply With Quote