Sum total cells to change colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can this be done?
once the sum total of a column reaches a set figure all cells there after to
change the background colour.
Col D = total entered.
Cell H3 is the figure at which the cells change colour. This figure can be
change if needs be.
 
Look in help for conditional formatting, select the range in D, assume the
values start in D1
do format>conditional formatting, select formula is

=SUM($D$1:D1)>=$H$3

click the format button and select the format you want, then click OK twice


--


Regards,


Peo Sjoblom
 
Thank you Peo. Just one more question, if I may!
Data runs from D11 to D60000 and dates are on column "A" and this covers the
whole year. Is it possible to do the same for each month on one sheet?
 
Back
Top