Forum Discussion
Excel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number ...
How the cells are made color? It is via conditional formatting or manually? If the color is made by conditional formatting then we could use same formula to count/some values.
The cells are manually highlighted to green. The idea is that individuals can mark the dates on the rota that they would prefer with a "Yes" from the drop down list in each cell. Then management can review and manually highlight in green which ones they have authorised. The authorised cells should then be counted as part of the quarterly total.