Hey Kenneth,

First off, thanks for your time and your help. It is GREATLY appreciated.

Im honestly not sure which way to go about it would be better. I thought conditional formatting was based on formating to the specified conditions only if it meets the specified criterias. Im not sure that can be used here unless it is towards the later part of the code.

As in:

IF a row was copy and pasted from "MySheet" to "New Propert", THEN Highlight that added rows cell in Column A Pink RGB(255, 0, 255).

Like I said before i am honestly not sure what the best way to approach this code is. I unfortunately am novice with VBA (but would really love to learn it).

I have attached an example Workbook. there are 3 sheets in the work book. "New Property", "MySheet", and "FINAL". Sheet "FINAL" is what "New Property" should look like after the macro is ran. As you can see in sheet "FINAL", the rows that were copied from "MySheet" (because they meet the criteria of having the color Blue RGB(79, 129, 189) or Purple RGB (204, 192, 218) in Column C) and inserted into the last row of the sheet "FINAL" and the cell in column A for those rows that were moved were highlighted Pink RGB(255, 0, 255).

Sample Report.xls

Thank you again for your help.
Zlerp