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 currently made colour manually. The idea is that individuals can select their preferred dates on the rota spreadsheet using a drop down list entry of "Yes". Management would then manually highlight the cell green if they approve it.