Hello,

I need my macros to search for the word "Cancel" or "Cancelled" in columns "T" and "U". Once found, I need the macros to make that entire row an opaque shading.

There will be other wording in these cells that contain "Cancel" or "Cancelled". Is it possible for the macros to search in the sentence and find the words "Cancel" or "Cancelled"

I started on the code below but am stuck. 

Sub MakeOpaque()
Dim lRow As Long, nxtRow As Long, ColCnt As Long, a As Long
Dim MySheets As Variant
MySheets = Array("FY09 Installation Support", "FY09 Install", "FY09 Purchase", "FY09 CF Discretionary Grants", "FY09 CF LOI", "FY08 Purchase", "FY08 Installation Support", "FY08 CF Discretionary Grants", "FY07 Sup Install Support", "FY07 CF Install Non-LOI", "FY07 Sup Purchase", "FY05 CF Carryover Install", "FY04 Recovery Funds", "FY05 Recovery Funds", "FY08 Safety Carryover", "FY09 Safety", "FY09 Transport Canada")
Application.ScreenUpdating = False
For a = LBound(MySheets) To UBound(MySheets)
  With Worksheets(MySheets(a))
    ColCnt = .Columns.Count
    lRow = .Range("B" & .Rows.Count).End(xlUp).Row
    For nxtRow = lRow To 1 Step -1  ' i think this is for the row above?  i dont know
      If .Range("B" & nxtRow) = "Cancelled" Then
    
Next a
Application.ScreenUpdating = True
End Sub

Any ideas? Thank you for your help!