What Is Text That Contain In Conditional Formatting?

What Is Text That Contain In Conditional Formatting?

In Conditional Formatting “Text That Contain” is a function which highlights those cells' or the value that contains certain value or text defined by us while applying Text that contain formulas.

Please follow the below images for better understanding.

Click on conditional formating > Highlight cell rules > Text that Contain.

excel conditional formatting if cell contains specific text

Click on Text That Contains the new window open like below image and you can put value or text such as I want to highlight different text and value.

First I selected the cells from where I want to highlight text and put text ABC & apply formulas.

Second again I want to highlight and put text DEF & apply formulas.

Third again I want to highlight and put a value 101 & apply formulas.

But you can put any value or text that contain in a selected cell according to your work requirement.  

Note: You can use more than one conditional formatting on specific columns, rows or Values at a time.

excel conditional formatting text contains