Conditional formatting based on 2 criteria

[ugalskov]

Hi

I am looking for a way on how to highlight entire rows, based on 2 conditions:

Condition 1) Each cell has to exactly sum to zero (with another cell in the same column, i.e. Column B), and:
Condition 2) Have to be in the same group (in another column, i.e. Column A).

Column A Column B
Raw Data
Group Balance
Group 1 -500
Group 1 500
Group 2 -234
Group 3 234
Group 2 321
Group 3 -234
Group 2 100
Group 4 -101
Group 1 500

Result
Group Balance
Group 1 -500
Group 1 500
Group 2 -234
Group 3 234
Group 2 321
Group 3 -234
Group 2 100
Group 4 -101
Group 1 500


I have tried conditional formatting, but I have not being able to make it work, but I am sure one user could provide a suggestion. I also gladly welcome a VBA solution!

Any help is very appreciated.

/O

[FlameRetired]

ugalskov why is Group 2 -234 highlighted green? There are no Group 2 234.

What am I missing?

[ugalskov]

FlameRetired, you're right. Group 2 -234 shouldnt be highlighted

[samba_ravi]

bettor to attach a sample excel file and Group 1 sum also not equal to Zero

[ugalskov]

The site won't allow me to attach the sample excel file.