VBA Change Color of LOOKUP Cells That Save to Oriignal Cell

[LtSplinter]

Hello,

I know next to nothing about VBA coding and need some assistance.

My workbook has a macro in worksheet "Invoice Query". When you type something in C1 and click the macro button it will search 3 different tables/worksheets for that invoice # "CT Matching" "UnMatched-2019" "UnMatched-2018". If it finds a match it returns the row along with the cell's background color and tells me in which sheet it was found in.

The background color is done manually. It is not done through conditional formatting.

What I am looking for is to be able to change the background color of those searched results in "Invoice Query" and have it change the original cells from wherever it pulled the results from.