Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings,
The following VBA works perfecting proving there are no addition text the cell. I can I tweak it just a little to it will highlight anytime the word Local is in the cell no matter if there is data in front or back? Thank you,
The following VBA works perfecting proving there are no addition text the cell. I can I tweak it just a little to it will highlight anytime the word Local is in the cell no matter if there is data in front or back? Thank you,
VBA Code:
Sub Local_BACKGROUND()
Sheets("72 Hr").Select
endrow = Range("E" & Rows.Count).End(xlUp).Row
For Each cell In Range("E3:E" & endrow)
If cell.Value = "LOCAL" Then
Range(Cells(cell.Row, "A"), Cells(cell.Row, "E")).Interior.ColorIndex = 6
End If
Next
End Sub