I have a spreadsheet, and there are various drop-down menus on it to select various criteria.
When certain criteria is selected then data in different cells show up in various colours. I have used conditional formatting for this.
I now need to be able to auto-count the data in accordance to its colour.
So, for example:
- rows 1, 3, 4, and 7 are green
- rows 2 and 6 are blue
- row 5 is yellow
How do I count green rows, blue rows and yellow rows individually, and display the numbers in a different cell? Remembering that these rows are default white, and only change to their colours when relevant criteria is selected from the drop down boxes.
Have tried (for example)
=IF($A1:$A9)='White' but I'm not sure how to format it to reflect the colour of the text, rather than the text itself.