is there anyway i can use the formula =ROUNDUP(SUM(C13*60*$D$19*$I$22),0.5)
in a column until the column total reaches 600 then have the formula change to =ROUNDUP(SUM(C13*60*$D$20*$I$22),0.5). changing one of the cells in the formula. i would also like the column to turn a different colour at this point if possible.