How to add a drop-down list to an Excel cell and conditional color formatting

To add drop-down list to a sheet, do the following: Create the list in cells A1:A4. Similarly, you can enter the items in a single row, such as A1:D1. Select cell E3. (You can position the drop-down list in most any cell or even multiple cells.) Choose Validation from the Data menu. Choose List from… Continue reading How to add a drop-down list to an Excel cell and conditional color formatting