Dim row As Integer row = 8 For row = 8 To Rownum FourNum = Cells(row, 13).Value Rmap = Cells(row, 10).Value CRMAP = Cells(row, 5).Value CRMAD = Cells(row, 4).Value Descript = Cells(row, 3).Value 'Highlight Deletes If FourNum < AFourwk And CRMAD > ACRMAD And CRMAP > ACRMAPercent Then Rows(row).Interior.ColorIndex = 37 If FourNum > SFourwk And Rmap < SRMAPercent And CRMAP < SCRMAPercent Then Rows(row).Interior.ColorIndex = 35 If Cells(row, 3).Value = "=search(""private"",descript)" = 1 Then Rows(row).Interior.ColorIndex = xlNone Next row
This is what I have for my code
Looking at this part specifically. What I want the code to do is look in column 3 of the worksheet for every instance of word "private" and when it finds it, I want it to shade that whole row clear.
Any ideas? Thanks a lot for the help.