Jul 06 2021 02:28 PM
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.
Jul 06 2021 03:15 PM
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).