Excel Formulas to Highlight the Cells that Equal to Certain Criteria!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-03-24 04:06:27

---
title: Excel Formulas to Highlight the Cells that Equal to Certain Criteria!!
published: true
date: 2021-03-23 11:54:06 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-the-cells-that-equal-to-certain-criteria/
---

In Excel, sometimes you need to format the cells that contain the same value. How could you deal with this task in Excel? Here are some cute formulas for you to **highlight the cells that equal certain conditions or criteria in Excel**. Let’s get into this article!! 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)

[![Formula to Hightlight cells that equal](https://geekexcel.com/wp-content/uploads/2021/03/Formula-to-Hightlight-cells-that-equal.png)](https://geekexcel.com/excel-formulas-to-highlight-the-cells-that-equal-to-certain-criteria/formula-to-hightlight-cells-that-equal/#main)<figcaption id="caption-attachment-22634">Formula to Highlight cells that equal</figcaption>
## General Formula:

- You can apply the below formula in the conditional formatting option to highlight the value that meets certain criteria.

**=A1=”text”**

## Syntax Explanations:

- **A1** – It represents the input value.
- **Text** – It is the criteria that want to format.

## Practical Example:

Refer to the below example image.

- Here, we will enter the input values in **Column B** and **Column C**.
- Now we are going to highlight the cells in **Column C** based on that equals to the given criteria in **Column D**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-28.png)<figcaption id="caption-attachment-22635">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, we will get the result as shown below.

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

## Wrap-Up:

Here, we have guided you to learn how to **highlight the cells that equal certain criteria in Excel**. Hope you like this article. Please feel free to state your **query** or **feedback** for the above article. Thank you for visiting our site!! Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Apply Conditional formatting Dates Overlap!!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-dates-overlap/)**
- **[Excel Formulas to Highlight 3 Smallest Values with Criteria!!](https://geekexcel.com/excel-formulas-to-highlight-3-smallest-values-with-criteria/)**
- **[Formulas to Apply Conditional Formatting based on Another Cell!!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-another-cell/)**
- **[Excel Formulas to Calculate the Tax Rate with Fixed Base with IF Function!](https://geekexcel.com/excel-formulas-to-calculate-the-tax-rate-with-fixed-base-with-if-function/)**