Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings I am hope to adjust the macro so that it will highlight the row between Columns A:E. I want this particular Maco to do it's job any time "CUST & AG REQ" occurs anywhere in Column E. "CUST & AG REQ" can appear anywhere in Column E, and I don't want to list all the variances that it can occure.
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)
Select Case cell.Value
Case "CUST & AG REQ"
Range(Cells(cell.Row, "A"), Cells(cell.Row, "E")).Interior.ColorIndex = 45
End Select
Next cell
End Sub