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.

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.

To change Gridline color in Excel, use Excel Options, apply a custom-colored border to the cells, or apply a custom line color. Full details here.

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns/fields.

Learn how to how to increment numbers when value changes in another column. You can automatically fill increment cells in Excel such that the increment value across each cell remains constant.

How to Use If-Then Excel Equations to Color Cells. If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others ...

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.

Highlighting cells with different colors can help you quickly identify information in a spreadsheet. Excel also lets you sort by color to easily group all the information you’ve highlighted with a ...