Excel Formulas to Apply Conditional Formatting based on Another Cell!!
Tags: conditionalformattin, excelformula, excelformulas
Published: 2021-03-11 09:08:03

---
title: Excel Formulas to Apply Conditional Formatting based on Another Cell!!
published: true
date: 2021-03-11 09:06:03 UTC
tags: conditionalformattin,ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-another-cell/
---

A conditional format **changes the appearance of cells** based on certain criteria. If the condition is true, the cell range is formatted otherwise it is not formatted. In this short tutorial, we will show the simple steps to **apply the conditional formatting based on a value in another cell in Excel**. 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)

[![Conditional based on another cell value](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_faVZFSkLrL.png)](https://geekexcel.com/?attachment_id=22405#main)<figcaption id="caption-attachment-22405">Conditional based on another cell value</figcaption>
## General Formula:

- Here we will show the simple formula to format the cells in Excel.

**=A1>=[$J$1](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)**

## Syntax Explanations:

- **Absolute Reference ($)** – The [**Absolute reference**](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) is an actual fixed location in a worksheet.

## Example:

Let’s see the below example image. Here we will format the cell value based on another cell.

- First, we will enter input values in **Column B** to **Column D** , and we want to format the cells which are greater than the certain value given in **Column F**.

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

- Apply the 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 results as per the below image.

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

## Closure:

From this tutorial, you can get to know the simple steps used to **apply the conditional formatting based on a value in another cell in Excel**. Hope you like it. If you have any doubts, feel free to share them with us. Thanks for visiting **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[How to Highlight All Errors Using Macros (VBA) In Excel Office 365?](https://geekexcel.com/how-to-highlight-all-errors-using-macros-vba-in-excel-office-365/)**
- **[Excel Formulas to Highlight 3 Smallest Values with Criteria!!](https://geekexcel.com/excel-formulas-to-highlight-3-smallest-values-with-criteria/)**
- **[Highlight Count a Specified Value using Macros in Excel 365!!](https://geekexcel.com/highlight-count-a-specified-value-using-macros-in-excel-365/)**
- **[Excel Formulas to Get Location of Value in 2D Array!!](https://geekexcel.com/excel-formulas-get-location-of-value-in-2d-array/)**
- **[Excel Formulas to Return the Empty or Blank Value with IF Function!!](https://geekexcel.com/excel-formulas-return-blank-empty-with-if-function/)**