Is there a way to find and highlight a combination of cells that sums to a specified amount?

MTaber

I have a sheet with $ to be paid that a vendor uses to issue quarterly checks, but the check doesn't match the total on the sheet. Is there a way to solve which lines are being paid with the check? Thinking of a formula that would highlight the combination of cells that add up to a specified amount (in this case, $99,979.04). Snip of trimmed down sheet below:

jjg279

Would the check always cover a "whole" amount from a PO? If so you could make a sheet to SUMIF all the lines under each PO then look for the total; possibly excluding based on PO status or a date? Or maybe nest any charges that are more than one line and sum the children?