How to use Conditional Formatting if 360, cells automatically changing colour red

[redza]

Hi all.

I need help. I have figure A1 column which total amount accounting at cells A31. I need figure 360 as a benchmark calculation perfectly been done. In this calculation 360 well off inside cells A18 although actual number is 363. If we use Conditional Formatting when had enough total in cells the achieve 360, cells colour will be transformed to red. What formula which need I used to change no matter cells on A1 to A30 if sufficient study 360 automatically cells changing colour to red

[humdingaling]

are you able to attach spreadsheet with example of data before and after

finding it hard to follow the question is
i believe i know what you want to do but.....better if you tell me directly then me guessing

[humdingaling]

try this conditional format
=SUM($A$1:$A$30)>360
apply to $A$1:$A$30

[redza]

Attached example file. When inside total one of the A1 cells to A30 has achieved 360, cells inside radius 360 will change to red colour automatically

[redza]

try this conditional format
=SUM($A$1:$A$30)>360
apply to $A$1:$A$30

Thanks humdingaling. Formula that you give have successfully resolved my problem

[humdingaling]

cant think of way to only do one cell without making a whole heap of conditional formats

would you take anything below that point?
=SUM($A$1:$A1)>360
applies to =$A$1:$A$30