How to Remove Certain Colors in Excel 2007. Microsoft Excel 2007 introduced means of sorting and filtering your data by the color of your cells and their text contents. When you use color to ...

How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.

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.

I have a set of spreadsheets where the data (text) is color-coded by row. Would it be feasible to write a formula or script to count how many of what color rows are spread across the workbooks in ...

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.