I have searched far and wide but maybe I'm just trying to use the wrong type of loop. I want my loop to apply conditional formatting to every line of an invoice spreadsheet until it gets to a line for the customer signature, but the text in this line is not the same in every spreadsheet, so I just want it to stop when it gets to a line containing the text "customer". Can anyone help me out?

Do Until ActiveCell.FormulaR1C1 = "CUSTOMER SIGNATURE _______________________________"
    
        With Selection.Font
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = -0.349986266670736
    End With

    Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=RC3>0"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Font
        .ThemeColor = xlThemeColorLight1
        .TintAndShade = 0
    End With
    Selection.FormatConditions(1).StopIfTrue = False
    ActiveCell.Offset(1, 0).Select
    Loop
Thanks in advance.