I have 12 columns
=SUM(B2:B32,H2:H29,N2:N32,T2:T31,Z2:Z32,AF2:AF31,AL2:AL32,AR2:AR32,AX2:AX31,BD2:BD32,BJ2:BJ31,BP2:BP32)
that formula adds them all up
what i need to happen is for a cell to highlight when the sum "1390" is reached. and this highlight of course would move depending on the amount in individual cells. i am sure this is doable but i can't figure it out.
Any help greatly appreciated!
sorry on rule misunderstanding!
Bookmarks