Sum total cells to change colour
 

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.
--
car

Sum total cells to change colour
 

Look in help for conditional formatting, select the range in D, assume the
values start in D1
do formatconditional 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



"Car" wrote in message
...
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.
--
car

Sum total cells to change colour
 

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?
--
car


"Peo Sjoblom" wrote:

Look in help for conditional formatting, select the range in D, assume the
values start in D1
do formatconditional 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



"Car" wrote in message
...
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.
--
car