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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

[pravinrin]

You shall use this

=AND($A$2="standard",$B$2=3,$C$2>=3,FIND("L2Ready:",$AC$2))