Forum Discussion
shetzel
Jul 07, 2022Brass Contributor
Excel help counting colors
Is there a way to count cell colors without having numbers in them without using ASAP Utilities. The attached spreadsheet is used for scheduling machines. My employees work many different hours and f...
HansVogelaar
Jul 07, 2022MVP
You have used conditional formatting, so you can use COUNTIF or COUNTIFS with the same criteria as used in the conditional formatting rules.
But the rules don't make sense to me - please review them carefully to check that they do what you want.