I have a complicated request come in that I am not sure is something that can be accomplished, but I wanted to check and see if anyone on here has been able to accomplish something like this.

They have a open purchase order saved search that shows the line level data and related records. They want to be able to highlight a line if there is the same item on a purchase order and a receipt was applied to a line that is due later than another line that was due sooner. So if there is a due date of 5/9 and the quantity received is 0 and there is a due date of 5/12 and 5/12 was received but 5/9 was not they want to highlight the received line.