Deleting Rows by Font

  • Hi, below is a code I use to delete entire row when a blank cell is found in column M. It works great! I would like to know if I can modify this and use it in a separate macro so that I can delete an entire row when a certain font is found in Column B. I know I can custom sort by font color. I have some names in Column B that are shaded a slightly lighter color and want to remove them after sorting. Thanks.

  • Could you attach a copy of your file? It would be easier to see how your data is organized and to test possible solutions. Include a detailed explanation

    of what you want to do using a few examples from your data and referring to specific cells, rows, columns and sheets. De-sensitize the data if necessary.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Here is an example of my sheet. In column B, Player10, Player20,.......to.......Player 120 are in a slightly lighter font. I would like to remove the rows where there are players in the lighter font, resort the sheet by column x, lowest to highest, remove any blank rows, renumber the list in column A and have the chart below show up on the 2nd row below the last player. In reality, the lighter fonts will not be in every 10th spot but randomly within the list. Also each week, there may be more or less players in this font. I have a macro that will sort and move all the lighter fonts to the bottom of the sheet where I can remove them but if I can accomplish it in one stroke, it would be better. Thanks again.

  • In the file you posted, I don't see any colour formatting for any player in column B. The font formatting is all "Automatic" (black). Could you please explain what you mean by:

    Quote


    Player10, Player20,.......to.......Player 120 are in a slightly lighter font

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • In the file you posted, I don't see any colour formatting for any player in column B. The font formatting is all "Automatic" (black). Could you please explain what you mean by:

    Hi, in Column B, cells 10,20,30,40,50,60,70,80,90,100,110 & 120 are all 1 shade lighter than black. If you custom sort by Column B, Font Color, they will all come to the top. I do this so the names don't stand out from the others when I send it out to the members.

  • Try:

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • You are very welcome. :)

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!