I have downloaded a bit of code that would sum a range based on the background color. The "Sum" portion of the function works on change now that I added "Application.Volatile" to the top of the code, however if I change the color of a cell, it doesn't recalculate.
I considered doing a Change Event, however I'm not sure how I need to reference the background color as the item that is changing. Any help here would be appreciated.
I considered doing a Change Event, however I'm not sure how I need to reference the background color as the item that is changing. Any help here would be appreciated.