Conditional Format Split Receipt

[BillySpivy]

Hello,

This is on the Transactions sheet. Is there a way to Conditional Format the 'Split Receipt' amounts (column H) red fill until the Split group amounts in column K are equal?

In one example in rows 11 to 13 the 'PAYMENT' amounts add up to 65.00 and I manually fill cell H13 red.

The Split groups will have the same Account, Date, and Payee. There will also be the word 'Split" in that group if it helps to derive a solution.

Thank you very much

[Bo_Ry]

Please try
CF formula applied to H5:H46


=(SUMIFS($K$5:$K$46,$B$5:$B$46,$B5,$C$5:$C$46,$C5,$E$5:$E$46,$E5,$F$5:$F$46,"Split")<>H5)*H5

[BillySpivy]

Perfect thanks so much.