How to Make a Checklist in Excel . With ... You can also color code the cell based on whether the values in cells B10 and B11 are equal. This is called Conditional Formatting.

This type of control is truly one of Excel’s most helpful features, because the drop-down list can be almost anything. In this case, we’ll use a list of color names at the sheet level.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.