Highlight rows conditioned on two criterias

[ole123]

Hi


I imagine this problem being solved by simple conditional formatting (or maybe vba?), however I am not sure how to go about it.

I have two columns, one with group names and one with numbers. I need to highlight the rows, where the positive and negative numbers equal to zero, if they are in the same group. Moreover, there could also be two or more negative numbers, which equal one positive number - these rows should also be highlighted.

So based on two conditions I need to highlight rows, where:
1) Each column cell has to equal zero for it to be highlighted (it could also be multiple cells that meet this condition), and
2) Have to be in the same group.

It would be a bonus if I could sort acsending the highlighted rows, starting with the largest numerical value, which meet the two above conditions.

I appreciate any input here

 

[rahulshewale1]

hiii,

Please find the attached formula.this formula can only extract match criteria .



Thanks
Rahul shewale

 

[ole123]

Thanks for you reply. What if I only want matching values, with no aggregate sum? Thus, if Column has values: 1000, -1000, and 1000, then only the two first numbers would be highlighted since they equal 0.