We like to have our data sorted. Sometimes, we might face the necessity to differentiate cells containing text from the entire dataset. In this article, I will explain step-by-step procedures to **highlight cell if contains text in Excel**. I hope it will be very helpful for you if you are looking for an efficient way to do so.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

## Step-by-Step Procedures to Highlight Cell If Contains Text in Excel

With the help of **Conditional Formatting **along with **the ISTEXT function**, we can highlight the cell if contains text in **Microsoft ****Excel**. Let’s dive into detail.

### Step 1: Create an Organized Dataset to Highlight Cell If Contains Text

- In order to differentiate cells containing text from the dataset, it is the first and foremost criterion to have a proper dataset with both text and numbers. Here, I have organized a dataset with the
**Product ID**,**Product**, and**Price**columns.

### Step 2: Assign a Formula for Conditional Formatting

- In order to separate cells containing text with
**Conditional Formatting**, we need to assign a formula. For this, select the entire dataset and go to the**Home**tab. - Next, click on
**Conditional Formatting**from the ribbon and choose**New Rule…**

- A
**New Formatting Rule**wizard will appear. Pick**Use a formula to determine which cells to format**from the**Select a Rule Type**section. - Then, insert the following formula in the
**Format values where this formula is true**section.

`=ISTEXT(B5)`

- Next, click on
**Format**to define the cell pattern containing text.

**Read More: Check If Cell Contains Text Then Return Value with Multiple Conditions in Excel**

### Step 3: Set Format for Cell to Highlight Cell If Contains Text

- After clicking on
**Format…**, we will have the**Format Cells**wizard. - Go to
**Fill**. - Pick a color according to your choice.

- Next, go to the
**Font**tab. - Make necessary adjustments from here. I have applied white color font with an
**Italic**style. - Afterward, click on
**OK**.

- Click
**OK**again to apply**Conditional Formatting**.

**Read More: If Cell Contains Text Then Add Text in Another Cell in Excel**

**Similar Readings**

**Sum If a Cell Contains Text in Excel (6 Suitable Formulas)****How to Sum If Cell Contains a Text in Excel (6 Suitable Examples)****Use VLOOKUP If Cell Contains a Word within Text in Excel****How to Assign Value If Cell Contains Word in Excel (4 Easy Ways)****If Cell Contains Text Then Return Value in Another Cell Using Excel Formula**

### Step 4: Highlighted Cell If Contains Text

- After following the above steps, we will have the cells containing text sorted.

## How to Highlight Cell If Contains Specific Text in Excel

There is a slight modification needed if we are going to highlight a cell that contains specific text. The details are described in the below section.

__Steps:__

- Select the entire dataset.
- Next, go to the
**Home**tab. - Choose
**New Rule…**from the**Conditional Formatting**feature.

- A wizard named
**New Formatting Rule**will appear. - Pick
**Use a formula to determine which cells to format**from the**Select a Rule Type**section. - Then, insert the following formula in the
**Format values where this formula is true**section.

`=$B5 =$C$12`

- Next, click on
**Format**and make the necessary specifications to define the cell pattern containing specific text. - Click on
**ENTER**to finish the process.

- Finally, we have highlighted cell that contains specific text.

**Read More: If Cell Contains Specific Text Then Add 1 in Excel (5 Examples)**

## Conclusion

At the end of this article, I like to add that I have tried to explain step-by-step procedures to **highlight cells if contains text in Excel**. It will be a great pleasure for me if this article helps any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using **Excel**.

## Related Articles

**How to Use IF & OR Functions with Text in Excel (3 Examples)****Use “Not Equal to” Operator for Text in Excel (5 Examples)****How to Return TRUE If Cell Contains Text in Excel (8 Easy Ways)****Use IF-THEN Statements with Text in Excel (7 Examples)****If Cell Contains Text Then Copy to Another Sheet in Excel****Check If Cell Contains Partial Text in Excel (5 Ways)****How to Check If Cell Contains Text Then Return Value in Excel**