Delete Entire Row if the color yellow is in Column E

[zone709]

Hi Not sure how to do this for color. I think yellow color is 65535 but if its not or it doesn't matter? Trying to use a macro for this.

 

[Fluff]

How about

Sub Macro2()
   Range("E:E").AutoFilter 1, RGB(255, 255, 0), xlFilterCellColor
   ActiveSheet.AutoFilter.Range.Offset(1).EntireRow.Delete
   ActiveSheet.AutoFilterMode = False
End Sub

 

[zone709]

Thanks i think o got it working right. I changed the offset from 1 to 0. because the first cell wouldnt delete the row if yellow

 

[Fluff]

I had assumed that you had a header row that you wanted to keep.
If you change the offset to 0 then the first row will be deleted regardless of colour.

 

[zone709]

ok good i understand thanks. My first row doesnt have a header.