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.
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