I have an excel list that I past data in the far right column. If any other data matches it highlights red. I remove the red as it indicates it is complete. I would like to automatically search out the red and delete it. However it is the two cells to the left that add together to create the red cell.

What VBA or button can I use to automatically remove the circled info?

Just removing duplicates only removes the red. But that messes up the formula needed to create that cell and shifts everything incorrectly. I either need to clear the two cells to the left and sort all data to the top or I need to delete all three cells circled and shift up.

I feel like I could some how edit this code to delete the cells to left of anything that is red.
enter image description here