View Single Post
 
Old 07-18-2023, 01:27 PM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 11 Office 2021
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 112
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default

Here is a VBA solution

Code:
Option Explicit

Option Compare Text
Sub Safeway()
    Dim rng As Range, c As Range
    Set rng = Range("B3:F14") 'Change this range to your actual range of data.
    For Each c In rng
        If InStr(c, "Safeway") > 0 Then
            c.EntireRow.Interior.ColorIndex = 6
        End If
    Next c
    MsgBox "Action Completed"
End Sub
Reply With Quote