Sum total cells to change colour

C

Car

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

Peo Sjoblom

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
 
C

Car

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove colour change 4
Calculations based on cell colour 9
Conditional formatting 3
how to get a warning when data is entered wrongly 12
cell colours to change according to totals 1
Sum macro 2
Count macro 2
Excel does not accept text format! 0

Top