Counts up to a value

[KirovHC]

I would like to count up to a certain value, if the value is reached then color the cell and continue the count until the value is reached again.
In the following example the fixed value is 100, I hope to make you understand what exactly I need.
Thanks in advance to anyone who wants to help me

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B
1
2		20
3		50
4		34
5		50
6		46
7
8
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B8	Expression	=INT(SUM(B$2:B2)/100)>INT(SUM(B$1:B1)/100)	text	NO

 

[KirovHC]

How about

+Fluff 1.xlsm
	A	B
1
2		20
3		50
4		34
5		50
6		46
7
8
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B8	Expression	=INT(SUM(B$2:B2)/100)>INT(SUM(B$1:B1)/100)	text	NO

Not sure if that's exactly what i'm looking for.
Could you explain the logic of the formula?

 

[Fluff]

It checks to see if the sum has gone over the next band of 100.

 

[KirovHC]

It checks to see if the sum has gone over the next band of 100.

What I would like is that it automatically add the difference of the cells in the next sum.
I mean, the sum is unlikely to get to exactly 100, what I would like is for the difference to be added to the count.
EDIT: i think it has to be done with visual basic, i don't think conditional formatting can fulfill the purpose

 

[Fluff]

If you look at the mini sheet in my post, is that not what you asked for?

 

[KirovHC]

If you look at the mini sheet in my post, is that not what you asked for?

in the example it is what I am looking for but I can not put it into practice, sorry but I am very rusty

 

[Fluff]

Select B3 to the end of the data & in conditional formatting, new rule, use a formula, & enter the formula I showed.

 

[KirovHC]

Select B3 to the end of the data & in conditional formatting, new rule, use a formula, & enter the formula I showed.

What's wrong?

Nuovo Foglio di lavoro di Microsoft Excel.xlsx
	A	B
1	DATE	COUNT
2	01-gen	20
3	02-gen	120
4	03-gen	34
5	04-gen	50
6	05-gen	46
7	06-gen
Foglio1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B6	Expression	=INT(SUM(B$2:B2)/100)>INT(SUM(B$1:B1)/100)	text	NO

 

[Fluff]

Are the values in col B actual numbers or text?
Put this in C2 copied down & what does it return

=ISNUMBER(B2)