Forum Discussion
jobrown
May 03, 2021Copper Contributor
is there a way to count cells of certain color in spreadsheet?
Is there a way to count cells of certain color in spreadsheet? ie. Want to count the cells that are green, so thought the following syntax would work...=countif (range, Cell("color" = green), but i...
HansVogelaar
May 03, 2021MVP
COUNTIF only counts cells with a specific value.
See Color Functions In Excel for some custom VBA functions.