Forum Discussion
Excel Solution Required
PART ONE:
Let's say the cells with the drop-down are A2:A100.
Number of cells with Distinction:
=COUNTIF(A2:A100, "Distinction")
And similar for the other options.
PART TWO:
If the cells are colored directly (not through conditional formatting), counting cells with a specific color requires VBA, so all users would have to allow macros. And it would only work in the desktop version of Excel for Windows and Mac, not in Excel Online, nor on iOS/Android.
Do you really want this?
- Thanks Hans, hmmm... with regard to Part Two, I don't know what VBA is, but basically in the cell there is a deadline date, my team colour it red if it's not been met and green if it has, I simply wanted to output the number of green cells and the number of reds, is there another way to do this?
Thank you in advanceIf the cell is colored red when the deadline date has been passed, you could use a conditional formatting rule to so.
And you could use a COUNTIF formula that looks at the dates to count those that have passed.
If necessary, you could use another column to record additional needed information.
Without knowing the setup, it's difficult to provide more detailed help.
- Hi Hans, thank you for your help.. so, the dates are fixed, the team doesn't need to enter the dates at all, the team simply colours the cell red or green. Based on that - how would I get the data I require?
