-
Delete rows ONLY IF duplicate value in column A + cell is highlighted Specific Color.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules