How to format row if sum value of row equal specific value

[trungtb]

I use excel and i have sheet look like :

A        B            C
1        3927269      58516305
2        2356361
3        2749088
4        294545
5        13156350
6        1570908
7        1963634
8        5105449
9        3632724
10       3141815
11       7996358
12       3534542
13       29963613
14       .....

Now i want filter all row from 1 -> 13 and highlight specific row only when sum row hightlight = C1
Example : B2+B3+B6 = C1
Now B2,B3,B6 highlight
I using formula on Conditional Formatting look like: =SUM($B$1:B1)=$C$1. But it not working. How to highlight rows only sum value equal specific value ?

 

[Fluff]

Duplicate to: How to format row if sum value of row equal specific value

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.