May 03 2021 10:32 AM
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 it only returns a number of zero when I have several green cells.
May 03 2021 11:04 AM
COUNTIF only counts cells with a specific value.
See Color Functions In Excel for some custom VBA functions.