I have a range of cells that has conditional format applied to fill the cell with yellow for example.

I want to be able to get a count of how many of those cells are filled yellow. The normal "count by color" formulas don't seem to work because of the conditional formatting.

I'd like the count to be updated whenever any cell in the workbook is updated.

Any help would be appreciated