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

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

In the previous post, we have learned the simple steps used to **format the cells based on another cell value in Excel**. Similarly, here we will show the quick steps used to **apply the conditional formatting based on another column in Excel**. Let’s get started!! 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 Formatting Based on Another Column](https://geekexcel.com/wp-content/uploads/2021/03/Conditional-Formatting-Based-on-Another-Column.png)](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-based-on-another-column/conditional-formatting-based-on-another-column/#main)<figcaption id="caption-attachment-22386">Conditional Formatting Based on Another Column</figcaption>
## General Formula:

- Here we will use the below formula to create a conditional formatting based on a value in another column.

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

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

## Practical Example:

Refer to the below example image.

- Here, we will give the input values in **Column B** to **Column D**.
- Now we are going to format **Column D** based on a given formula.

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

- So, apply the above-given formula to the conditional formatting option.
- If you want 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-16.png)<figcaption id="caption-attachment-22388">Result</figcaption>

## Verdict:

Hope you like this article on how to **apply the formula in the conditional formatting option based on another column in Excel**. Let me know your **queries** in the below **comment** section. I reply to queries frequently. Thanks for visiting **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Show Checkmark for Valid Inputs ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-show-checkmark-for-valid-inputs/)**
- **[Excel Formulas to Calculate the Shipping Cost with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-shipping-cost-with-vlookup/)**
- **[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 Used to Group the Numbers at Uneven Intervals!!](https://geekexcel.com/excel-formulas-group-numbers-at-uneven-intervals/)**
- **[Excel Formulas to Return the Empty or Blank Value with IF Function!!](https://geekexcel.com/excel-formulas-return-blank-empty-with-if-function/)**