Matching PO number with matchin negative value w/ corresponding positive value

[infra]

I have a spreadsheet of invoices and credits. Is there a way to highlight both the positive and negatives values in column H if they have matching PO No in column C as well as matching positive and negative value in H? For example in row 5 and 6, there is a matching PO No in C as well as matching value in H, I would like Excel to highlight the values in H5 and H6.


Thanks.

[ragulduy]

I think if you highlight column H and with H2 active apply this formula to the conditional formatting:
=SUMPRODUCT(IF(H$2:H$100=-H2,1,0),IF(C$2:C$100=C2,1,0))>0
it would do what you want.

[benishiryo]

hi infra. another alternative. select the range you want to apply to (say from H2:H73)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=COUNTIFS($C:$C,C2,$H:$H,-$H2)

[infra]

Hi! guys,

Thank you very much for your help. It indeed solve my problem.

By the way, should I decide to delete the matching values, how should I do it?

Once again, thank you.