Forum Discussion
use sumif function when criteria is cell hihlighted with a color highlight
I want to use sumif function to add a column of numbers when criteria is a fill color in the cells. How do I do this.
How do you make this auto update when color is added to the cells within the range?
As I mentioned in another reply, updating is not automatic - changing a cell's color does not trigger an event in Excel. You'll have to press F9 to update the result.
Ok, thank you. I missed that post.
