With Microsoft Excel ... list instead of entering data. You can further tailor the spreadsheet by using conditional formatting to fill the cell with a specific color depending on which list ...

Throughout this article, we’ll use Excel’s built-in data validation drop-down ... You could just as easily use the Fill property instead. How to change the color of a cell in an Excel drop ...

Can Excel sort by color ... Move the cursor anywhere inside the data range, press Ctrl+A to highlight everything. 5. Under Sort On, choose Cell Color from the drop-down list.