Conditional Formatting based on partial/specific text to Change formating

I currently use a basic conditional formatting rule to use different formatting, example.

Rule: "Format only cells that contain"
Cell Value: Equal To: ="T1"
Rules applied to range: =$C$7:$J$29

Any cell any text with "T1" text is highlighted in Yellow. Previously the text was always the same, either "T1" or "T2" in a separate cell which had it's own rule. However we now have cases where "T1" and "T2" are in the same cell, example "T1, T2", or "K3, P1" so my basic rules no longer work as the combinations can be anything. Previously the combinations were always the same (example: "K2, K3, K5").

Is there a way to match the rule using Cell Value: "Contains" instead of "Equal to" so I can match based on the just one value and then apply formatting?

2021-01-23_11-30-59.png

EXCEL_2021-01-23_11-32-28.png

Originally Posted by kvsrinivasamurthy

For Contains ( say "aaaaa")use this for cell K1

=Isnumber(Search("aaaaa",K1))

Thanks

Originally Posted by etaf

You can use a search
See attached sheet - with RED for K2 and GREEN K6

Two Rules in Conditional formatting
One for RED
=SEARCH("*K2*",$A1)
ONE for Green
=SEARCH("*K6*",$A1)

And the Cell where you start you selection

If you attach your spreadsheet as show in the YELLOW BANNER , that would help rather then a image

Thank You! this one worked for me example=SEARCH("*K2*"|C7)