Excel Formulas to Highlight Rows that Contains a Specific Text!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-04-03 10:51:28

---
title: Excel Formulas to Highlight Rows that Contains a Specific Text!!
published: true
date: 2021-04-03 04:22:35 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-rows-that-contains-a-specific-text/
---

Sometimes we want to **highlight the rows if any cell in that row contains a specific text or value** in Excel. For achieving this you can use the conditional formatting option. This article provides some simple formulas to help you quickly get it done. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Highlight rows that contain specific text](https://geekexcel.com/wp-content/uploads/2021/04/Highlight-rows-that-contain-specific-text.png)](https://geekexcel.com/excel-formulas-to-highlight-rows-that-contains-a-specific-text/highlight-rows-that-contain-specific-text/#main)<figcaption id="caption-attachment-22797">Highlight rows that contain specific text</figcaption>

## General Formula:

- You can use the below formula to highlight the entire row that meets a certain condition.

**=[SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(text,cocatenated\_columns)**

## Syntax Explanations:

- **SEARCH** – The **[SEARCH function](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)** helps to locate the character between two text strings and returns to the number of the starting position of the first text string from the first character of the second text string.
- **Text** – It specifies the criteria value that you want to highlight.
- **Concatenated\_columns** – It represents all the column values from the same row.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B** to **Column E**.
- Now we want to highlight the entire row if any cell of that row contains the specific text which is given in **Column G.**

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-1.png)<figcaption id="caption-attachment-22794">Input Ranges</figcaption>

- So apply the above-given formula in the conditional formatting option.
- To know  **how to apply conditional formatting**  in Excel, just **refer to this article<u>:</u>[ How to Apply the Formula with Conditional Formatting In Excel?](https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/)**
- Finally, it will highlight the result and displayed it as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-1.png)<figcaption id="caption-attachment-22795">Result</figcaption>

## Wrap-Up:

From this short tutorial, we have discussed the simple formula used to **highlight the rows that contain specific text in Excel**. If you have any **doubts** or **queries** mention them in the **comment** box below. Thank you. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Highlight Numbers Include Symbols ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-numbers-include-symbols/)**
- **[Excel Formulas to Highlight the Integer Values Only ~ A Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-the-integer-values-only/)**