Hello,

I need a special conditional formatting. The situation is this.

In column "A" I have unique IDs (lets assume names), which can repeat in rows (this is important) but not necessarily. To each unique value belongs a value in a different column "B". I need to highlight a situation when to a specific unique ID in column "A" the SUM of the values in column "B" reach a certain value.

Example:

If to a certain ID the SUM of the values in column "B" reach "10" then should be highlighted the row (or cell).

ID Value

Peter 5

Suzanne 2

Andrew 3

Thomas 12

Peter 6

Mia 9

Donald 10

Boris 4