Hello All,

I am looking for a Macro that will look at 2 sheets in the same workbook and if a cell in column C is highlighted either Blue [RGB (79, 129, 189)] or Purple [RGB (204, 192, 218)] then i want that row of data to be copied (format, cell highlights, etc...) from one sheet and inserted into another sheet.

This macro will look at a Sheet called "MySheet" and check through column C starting at C4 to the last row and look at the highlighted colors of the cells. If the cell is highlighted RGB(79, 129, 189) or RGB (204, 192, 218)then that row of data that ranges from A:P will be copied and pasted (including format and cell highlights) into the sheet called "New Property". If a row is copied and pasted from "MySheet" to "New Property" then I would like cell A for that row to be highlighted Pink RGB(255, 0, 255) so that it stands out and I know what has been moved from one sheet to the other.

If you have any questions or are not sure exactly what I'm asking, please ask.

Thank you for your time,
Zlerp