Delete rows based on multiple criteria including COLOUR, or while FILTERED

The example worksheet shows the results of code run to identify numbers in column B which are triplicates (and above). The cell of these is then coloured CYAN (0, 255, 255).

What I want to do now is delete the entire row where only these triplicates (and above) have the same name in both column F and G.

There are other rows with same names in F and G, but if B is not CYAN, they stay.

The problem:

When I FILTER column B on the Cyan cell colour then run code to remove the “same names” in F and G, this code does not work because the list is filtered.

If I run the code on an unfiltered list, all “same names” in F and G get deleted, including the rows I want to keep.

What I need is code to EITHER:

Delete only the qualifying rows when the list is filtered, or, include the colour Cyan in a three criteria code on an unfiltered list e.g. B = Cyan (0, 255, 255), F = same name as G, and G = same name as F.

Note: The names for F and G are referenced from Sheet 2 but it is possible that this may not be needed if F = G and G= F. This is best left to you code masters as to which option is best.

Here you go:

Please Login or Register  to view this content.

I first used code to find the B column color, then used that to make the determination to delete rows. Let us know if you have questions

Thank you. This brilliant.

If that takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.