Skip to content

How to Auto Mark/Color Excel Cells Containing Specific Text

How to mark and color excel cells/ranges that contain certain text with the Excel conditional formatting feature automatically

How to Auto Mark/Color Excel Cells Containing Specific Text
How to Auto Mark/Color Excel Cells Containing Specific Text

Conditional Formatting Text in Excel

Previously we have learned Excel on how to mark cells that contain certain numbers with features Conditional Formatting.

In this excel tutorial, we will learn about how to automatically mark or color Excel cells containing text according to certain criteria.

Text Criteria in Excel Conditional Formatting

For text criteria, excel conditional formatting provides 4 (four) criteria models that we can apply.

  1. Container: Marks Excel cells that are contains/contains text certain.
  2. Not Containing: Marks Excel cells that are does not contain/contain text certain.
  3. Beginning With: Marks Excel cells that are begins with text certain.
  4. Ending With: Marks Excel cells that are ends with text certain.

How to Mark Excel Cells Containing Specific Text

As an example we will use the following data table:

How to mark cells containing text 1

From the data table above we want to change the cell color automatically or mark cells that contain text “Repeat“with color red fill. The steps we need to mark or color cells with one of the four criteria above are:

  1. Selection of the data range that we will mark (H2:H11)
  2. Select menu Home--Conditional Formatting--New Rule
  3. select Format only cells that contain.
  4. On options Rule Description select Specific Text--Container
  5. Enter text “Repeat” in the box next to it.
  6. Set the red fill format or according to what we want.
  7. OK and done. See the results.

To explain further, consider the following pictures:

How to mark cells containing text 2
How to mark text based on certain criteria in excel

Create by ipadguides in category of Excel Class