Forum Discussion
Assigning a value to a color and averaging?
So it is a little complicated and based on everything I've read I think I'll have to assign an underlying value to every single cell and I really don't want to do that. Basically, I have made a k...
Sleep_is_key73 Google for "counting cells by colour excel" and you'll find many resources describing how this can be done. In your situation it most likely requires a small user defined VBA function that allows you to count cells of a particular colour in a range. Once you now how many cells of each colour you have, you can do your calculations, I guess.