this is a minor piece of what i am looking to build....

but the color is used when a certain person does something....each memeber of the team has a color.

so say step one is process a request.....I would want it to look down the column for Process request, in the given date range....and tell me how many times it sees the color yellow, Gray, Blue....etc

granted the sheet that I would do this....each color would have its own cell...so a tolal for yellow
a total for blue
a total for gray.