How to Apply the Formula with Conditional Formatting In Excel?
Tags: excel, excelformula, excelformulas, formulawithcondition
Published: 2021-03-11 03:57:14

---
title: How to Apply the Formula with Conditional Formatting In Excel?
published: true
date: 2021-03-10 04:33:54 UTC
tags: Excel,ExcelFormula,Excelformulas,FormulawithCondition
canonical_url: https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/
---

In this tutorial, we are going to learn how to **apply the Excel formula to format or highlight the cells with the Conditional Formatting Option**. Let’s get into this article!!

## Steps to create a condition formatting rule using a formula:

To set up a conditional formatting rule based on a formula in Excel, just follow the below steps:

- First, you need to **select the cells** that you want to format/highlight.
- Then go to the **“Home”** tab under the **“Ribbon”,** and click the **“Conditional Formatting” ** option.

![Select Conditional Formatting Option](https://geekexcel.com/wp-content/uploads/2021/03/Select-Home.png)<figcaption id="caption-attachment-22364">Select Conditional Formatting Option</figcaption>

- It will expand the **drop-down** list and here you need to select the **“New Rule”** option.

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

- In the **New Formatting Rule** window, you need to select the **“Use a formula to determine which cells to format” ** option.

![Select formula option](https://geekexcel.com/wp-content/uploads/2021/03/Select-formula-option.png)<figcaption id="caption-attachment-22333">Select formula option</figcaption>

- **Enter the formula** in the corresponding box and click the **“Format”** button.

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

- It will open the  **Format cells** dialog box, and choose the custom format **(such as font, color, pattern)** that you like to fill the tab then click on the **“OK”**  button.

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

- Make sure the  **Preview** section displays the format that you selected and click the **“OK”** button.

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

- Finally, it will **format/highlight** the selected cell values and display the result as per the below image.

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

## Conclusion:

From this short tutorial, you can some clarification on **how to apply the formula to highlight the cell by using the Conditional formatting option in Excel**. Hope that this article is useful to you!! Please state your **queries** about this article!! Thanks for visiting **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[How to Use Formula Bar for Various Purpose in Excel 365](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**
- **[Ribbon Keyboard Shortcut Keys in Microsoft Excel 365!!!](https://geekexcel.com/ribbon-keyboard-shortcut-keys-in-microsoft-excel-365/)**
- **[How to Calculate the Sum of Numbers Without using Formula in Excel!!](https://geekexcel.com/calculate-sum-without-formula/)**