Then, you can switch to the Format menu and Fill tab to choose the color as per your requirements. How to set color to alternate rows and columns in Excel?

How to Fill Colors in a List in Excel. With Microsoft Excel, you can simplify data entry by adding a drop-down list to a cell, allowing users to pick an option from the list instead of entering data.

Return to Excel and start clicking cells. Each time you change the selection, you trigger the procedure, which changes the fill color of the active cell, temporarily.