I have a worksheet that is Conditionally Formatted to fill a cell red (color = 255) when the condition is met. I would like to delete all rows that have a red filled cell in Column A.
As an alternative, can I skip the color formatting and and have the code delete every row in Column A that contains certain text strings are found? As an example, I would like to delete every row that has either "Test 1", "Test 2", or "Test 3" in Column A.
Thanks !!
Bookmarks