Hello All,

I am looking for a Macro that will look thorugh a Sheet called "New Property" (may not be active sheet at time) in column A for Duplicate values. If there is a duplicate value and the cell color is Pink RGB(255, 0, 255) , Then i want that entire row deleted.


The Row is deleted only if the following Criterias are BOTH met:

1. There is a Duplicate Value in Column A
2. Cell color in Column A is Pink RGB(255, 0, 255)


Thanks you for your time and Help. Any input is greatly appreciated!
Zlerp