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.

This article provides step-by-step instructions for color customizing your drop-down list in Microsoft Excel.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

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?

You can change the default color of chart, graph, treemap, etc. in Word, Excel, and PowerPoint with the helpof these simple steps.