Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and ...

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.

In the resulting submenu, choose either cell or font color. Filtering by the conditional format was easy, but the SUM() function doesn’t reflect the data that you see.

Launch Microsoft Excel. Click the Developer tab, then click the Visual Basic button. Once the VBA Editor is open, type the code to change the color of the cell.

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 Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set.