Dear experts,
In my worksheets I have a "traffic light" system where cells with particular
values turn assigned cells in another location red, green or yellow using
conditional formatting. This provides me with a quick reference. My
question is can I count cells according to their colouring. Then I could say
I've got 20 cases complete, 10 cases in process, and 2 cases pending for
example. I know I could count the cells at the site of the original data but
counting the "traffic lights" would add to my summary info.
Thanks
JC