Delete NON HIGHLIGHTED rows

[joyousrob]

Hi guys.
Using conditional formating of a certain Word I have selected a colum which now has highlighted and non highlited cells.
I would like to delete all the rows, where that colum (F) is not highlighted.
Any ideas?
Thanks

 

[kalak]

Hi guys.
Using conditional formating of a certain Word I have selected a colum which now has highlighted and non highlited cells.
I would like to delete all the rows, where that colum (F) is not highlighted.
Any ideas?
Thanks

By "highlighted" do you mean selected, or colored (say yellow), or perhaps other methods of highlighting?

 

[vcoolio]

Hello Joyousrob,


If you have a mix of high-lighted (coloured) and non high-lighted cells (no fill) in Column F, then the following code will clear the non high-lighted cells ,plus the relevant entire row of data:-

Sub ClearNonHighLighted()

Application.ScreenUpdating = False

     Dim lRow As Long

lRow = Range("F" & Rows.Count).End(xlUp).Row

For Each cell In Range("F2:F" & lRow)
     If cell.Interior.ColorIndex = xlNone Then
     cell.EntireRow.ClearContents
     End If
Next

Columns("A").SpecialCells(4).EntireRow.Delete
Application.ScreenUpdating = True

End Sub

I think that this is what you may be wanting.

I have attached my sample test work book for you to peruse.

https://www.dropbox.com/s/tbptoyqvusgmazh/Clear Rows of Non High Lighted Cells.xlsm?dl=0

Cheerio,
vcoolio.