Need help with continued conditional formatting with "AND"

[camar0]

This is an evolution from previous post:

http://www.excelforum.com/excel-work...or-1-cell.html

Current formula:

    Range("A2:O6000").Select
    Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=AND($B2=""Active"",$C2=""STANDARD"",$F2=4,$I2=""Level1-A"",$J2>=10)"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .Color = 255
        .TintAndShade = 0
    End With
    Selection.FormatConditions(1).StopIfTrue = False

Which works fine (highlights the complete row red) but I want to add another stipulation for "AND"

I want the formula to look for the word " L2Ready: " in cell AC2. The challenging part i see is that after " L2Ready: " will have different txt per cell....

The proposed:

    Range("A2:O6000").Select
    Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=AND($B2=""Active"",$C2=""STANDARD"",$F2=4,$I2=""Level1-A"",$AC2=""L2Ready:"")"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .Color = 255
        .TintAndShade = 0
    End With
    Selection.FormatConditions(1).StopIfTrue = False

Obviously will not work since there is more txt in $AC2 than just " L2Ready: "

Please help, thanks!



***** I decided to not use this as another field became available which was static