Color Column Once a Sum is Reached/Exceeded

[BondFan84]

Hi,

I have a user who would like have the items in a filtered column colored once a sum of the filtered column is reached/exceeded (in this case 5 million). At the moment there is no sum total cell, we get the sum total from the status bar. Is there a way to do this without a sum total cell or would we need to add a sum total cell? Sorry if this is not Macros related.

Thanks,

BondFan84

[Arkadi]

So you want color in all the cells UP TO and INCLUDING the cell that reaches the total?

[BondFan84]

Hi, sorry for the delay. Yes, that's correct. Once Column F is filtered for a specific item, it will produce items in Column J. I'd like Column J to be colored or highlighted when Column F filtered when it reaches or exceeds the limit of 5,000,000. Kind of like an alert saying the limit has been reached/exceeded. Hope that clears that up.

Thanks!

[BondFan84]

Can I provide any more information that would be useful or is what I'm asking not possible? I'd just like some sort of an alert with that column and maybe a popup might be better. My only issue is if the filtering would throw it off in any way.

[Arkadi]

Bond, sorry, I've been pretty busy in life and had not been on. Firstly do you have a workbook you can post? And second, I am not sure I get it 100%. The filters applied to F will add items to column J?
Basically, if I understand right, you want the total of column J items to be calculated whenever it changes, and an alert when the limit is reached correct?

Since filtering does not trigger any kind of worksheet event, is there a cell on the same sheet that we can put a formula in? it can be invisible, but it does need to have a formula if you want this to be automatic.