Forum Discussion
Count coloured cells based on conditional formatting
Can someone help me please? I am trying to get my spreadsheet to count cells based on their colour after they have been conditionally formatted. I have read various threads on here and made some progr...
Your workbook is not macro-enabled and you didn't add the function to your VBA environment.
However, you may use your rules logic in formulas to count the cells, like
=SUMPRODUCT(--($H$4:$H$182<$G$4:$G$182))