Forum Discussion
COUNTIF function but with conditional formatted cells
Hi, I have a spreadsheet that uses conditional formatting via a drop down list that the cell changes colour depending on result. I want to be able to count the number of cells that are certain co...
Instead of counting the cells by colour, count them based on the values of the cells.
- Hi i have found a function COUNTIFS that seems to work. Thanks
There isn't actually any values in the cell just a colour - or would it count the list value? Ive hidden the text by making it same colour as cell so only a colour shows.
