Counting cells with different colors

Occasional Visitor

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 using countif function after adding a column and using Cell function (=cell("color"a###), but the Cell function always returns 0, 0 even when the cell in Column A uses a different text color and fill).  I know how to use a macro, but I want to avoid having to save the spreadsheet as one that contains macros.  

1 Reply


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).