Using the instructions from a previous Excel drop down list article, create a drop down list in E4 using the color list as the source. To begin, add a new sheet and then add a new list with the text items red, blue, green, and yellow ( Figure A). You can work with your own data or download the demonstration. Learn how to add a new list and validation control, and then add the conditional format rules to include visual cues. Checklist: Securing Windows 10 systems (TechRepublic Premium)Ĭolor can be a powerful element in an Excel drop down list, and it's easier to add than you might think-you simply add conditional formatting rules to the cell containing the drop down list.Ten Windows 10 network commands everyone one should know.A new Microsoft Store: What does it mean for you and your business? A lot, actually.Windows 11 prep: How to convert MBR hard drive partitions to GPT.
