Dear Community
I need a formula that highlight values which total is zero but have the same reference ID
I want to have the below results.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I will really appreciate if you can support
Thank you in advance.
I need a formula that highlight values which total is zero but have the same reference ID
I want to have the below results.
ID | Value | Result |
A | 1 | highlighted on color green |
A | 2 | |
A | -1 | highlighted on color green |
C | 4 | |
C | -2 | highlighted on color green |
C | 2 | highlighted on color green |
A | 3 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I will really appreciate if you can support
Thank you in advance.