Forum Discussion
Counting cells with different colors
I have a spreadsheet that uses different colors for cells (NOT using Conditional Formatting). Is there a way to count the numbers of cells that have a specific color within a range. I thought of us...
CELL("color",A1) returns 1 if the number format of A1 specifies that negative numbers are displayed in color, 0 otherwise.
I am afraid that you will either need VBA code, or else use an add-in such as ASAP Utilities (free for home use).