Forum Discussion
Count color and add a value to Conditional formatting
Why don't use formal conditional formatting logic to count the totals?
If by color that's VBA, at least couple of threads are here
sum by color when colors are set by conditional formatting - Page 6 - Microsoft Tech Community
Thank you for the two links. The bottom link I have already followed. I just looked at the first link and there may be something in there that could work. But, I don't think it's going to assign a value to each of those colors. Unless I am not reading the VBA coding correctly. I do not have strong VBA skills so I am sure I am missing something.
At this point I have tried so many things that I may be confusing myself. If you come across a way to do what I am requesting and you can direct me how it works, that would be great!
VBA is not my territory, I didn't touch it for many years. That's better to ask people on mentioned thread.
