adding colored cells in excel 2007

[bparks41885]

Hello,

I am wanting to keep a running total of numbers that i have highlighted within a row. Then i want the numbers to zero out once cells are not highlighted. Can anyone help me?

 

[norulen]

See if this is what you are looking for
Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function - YouTube


OR may be this

Count Cells Based On Background Color