To compare any particular product price, availability, etc. in different times or seasons the greater than operator helps us. In this article, I’m going to explain how to highlight cell if value greater than another cell in Excel.

To make the explanation clearer and visible, I’ve taken a sample dataset. This dataset contains 4 columns that represent fruit prices in different seasons. These are ** Product Name, Spring Price, Summer Price, **and

**. Here, I will show you in which season the price is greater than from other seasons.**

*Winter Price***Table of Contents**hide

## Download to Practice

## 6 Ways to Excel Highlight Cell If Value Greater Than Another Cell

**1. Using Greater Than From Ribbon to Highlight Cell If Value Greater Than Another Cell **

The simplest way to **Highlight** a cell if the value is greater than another cell is using the **Greater Than **command ribbon.

To start the procedure,

First, select the cell or cell range to **Highlight **a value** Greater Than** another cell

➤ I selected the cell range **D4:D9**Then, open the

**Home**tab >> from

**Conditional Formatting**>> Go to

**Highlight Cells Rules**>> select

**Greater Than**

➤ A **dialog box** will pop up.

In **Format cells that are GREATER THAN **select the other cell with which you want to compare.

➤ Let’s select the **E4 **cell.

Then select any format to color where values are **Greater Than**.

➤ Here, I selected **Light Red Fill with Dark Red Text**.

Finally, click **OK**.

Thus, you will see all the values **Greater Than **from the selected cell will be **Highlighted **with the selected format.

*Here, the drawback is the selected value remains constant, it compares all selected range values with a constant value only.*

**Read more:** **Conditional Formatting Based On Another Cell in Excel**

### 2. Using Greater Than (>) Operator

You can use the **Greater Than (>) **operator to **Highlight **the cell if the value is greater than another cell.

To demonstrate the procedure, I’ll use the ** Spring Price **and

**columns.**

*Summer Price*Let’s begin the procedure,

To begin with, select the cell or cell range to **Highlight **a value** Greater Than** another cell

➤ I selected the cell range **C4:C9**Now, open the

**Home**tab >> from

**Conditional Formatting**>> select

**New Rule**

➤ A **dialog box** will pop up.

From **Select a Rule Type **select **Use a formula to determine which cells to format**.

➤ In **Format values where this formula is true **type the following formula.

`=C4>D4`

**Highlight**the cell.

Again, a **dialog box **will pop up. Select any color to **Highlight **your cell.

➤ I selected the **Clay Orange **color to fill.

Then, click **OK**.

In the end, click **OK**.

Therefore, It will **Highlight **the cell values of the ** Spring Price** column where it is

**Greater Than**the

**column.**

*Summer Price***Read more:** **Excel Conditional Formatting Based on Multiple Values of Another Cell**

### 3. Using Greater Than Equal (>=) Operator

You also can use the **Greater Than (>=) **operator to **Highlight **the cell if the value is greater than equal to another cell.

To demonstrate the procedure, I’ll use the ** Spring Price **and

**columns.**

*Winter Price*Let’s begin the procedure,

To begin with, select the cell or cell range to **Highlight **a value** Greater Than Equal **to another cell

➤ I selected the cell range **C4:C9**Now, open the

**Home**tab >> from

**Conditional Formatting**>> select

**New Rule**

➤ A **dialog box** will pop up.

From **Select a Rule Type **select **Use a formula to determine which cells to format**.

➤ In **Format values where this formula is true **type the following formula.

`=C4>=E4`

**➤ From**

**Format**select the format of your choice to

**Highlight**the cell where the value is

**Greater Than**

**Equal**.

*To choose the*.

**Format**follow the explained steps from**Method-2**

In the end, click **OK**.

Therefore, It will **Highlight **the cell values of the ** Spring Price** column where it is

**Greater Than Equal**to the

**column.**

*Winter Price***Similar Readings:**

**How to Do Conditional Formatting Based On Another Cell Range in Excel****Excel Conditional Formatting with Formula If Cell Contains Text****How to Highlight Highest Value in Excel (3 Quick Ways)****Do Conditional Formatting for Multiple Conditions (8 Ways)**

**4. Using Greater Than Equal (>) For Blank Cell **

You can use the **Greater Than (>) **operator with **the AND function** to **Highlight **a cell value greater than another cell while skipping **Blank Cell**.

Here, in my existing dataset, I’ve taken some **Blank Cells **in the ** Winter Price** column.

To start the procedure,

First, select the cell or cell range to **Highlight **a value** Greater Than** another cell except for **Blank Cell**.

➤ I selected the cell range **D4:D9**Now, open the

**Home**tab >> from

**Conditional Formatting**>> select

**New Rule**

➤ A **dialog box** will pop up.

From **Select a Rule Type **select **Use a formula to determine which cells to format**.

➤ In **Format values where this formula is true **type the following formula.

`=AND(D4>E4, $E4<>"")`

**Here, the**

**AND**function will check whether the cell

**D4**is

**greater than E4**then it will also check

**E4**is

**not equal**blank. If both conditions are fulfilled, then it will

**Highlight**the cell.

➤ From **Format **select the format of your choice to **Highlight **the cell.*To choose the Format follow the explained steps from Method-2*.

Finally, click **OK**.

Hence, It will **Highlight **the cell values of the ** Summer Price** column where it is

**Greater Than**the

**column, but you will see that the values that would be compared to the**

*Winter Price***Blank Cells**values are not

**Highlighted**as we skipped the

**Blank Cells**using

**$E4<>””**within the formula.

**Read more:** **Conditional Formatting for Blank Cells in Excel**

**5. Using IF to Highlight Cell If Value Greater Than Another Cell**

You can use **the IF function Highlight** cell if the value is greater than another cell.

To demonstrate the procedure, I’ll use the ** Spring Price **and

**columns.**

*Winter Price*Let’s begin the procedure,

To begin with, select the cell or cell range to **Highlight **a value** Greater Than** another cell

➤ I selected the cell range **C4:C9**Now, open the

**Home**tab >> from

**Conditional Formatting**>> select

**New Rule**

➤ A **dialog box** will pop up.

**Select a Rule Type **select **Use a formula to determine which cells to format**.

➤ In **Format values where this formula is true **type the following formula.

`=IF(C4>E4,C4,"")`

**Here, the**

**IF**function will check that cell

**C4**is

**greater than E4**. If the selected cell is

**greater than E4**then it will

**Highlight**the

**C4**cell otherwise won’t

**Highlight**.

➤ From **Format **select the format of your choice to **Highlight **the cell.*To choose the Format follow the explained steps from Method-2*.

In the end, click **OK**.

Therefore, It will **Highlight **the cell values of the ** Spring Price** column where it is

**Greater Than**the

**column.**

*Winter Price***Read more:** **Excel Conditional Formatting Formula with IF**

### 6. Using Average to Highlight Cell If Value Greater Than Another Cell

You can compare the average of the values while **Highlighting **a cell. To ease the task you can use **the Average function.**

To demonstrate the procedure, I’ll calculate the **Average **of the ** Summer Price, **and the

**column and will check whether the**

*Winter Price***column is**

*Spring Price***Greater Than**the calculated

**Average**or not.

Let’s begin the procedure,

To begin with, select the cell or cell range to **Highlight **a value** Greater Than** another cell

➤ I selected the cell range **C4:C9**Now, open the

**Home**tab >> from

**Conditional Formatting**>> select

**New Rule**

➤ A **dialog box** will pop up.

**Select a Rule Type **select **Use a formula to determine which cells to format**.

➤ In **Format values where this formula is true **type the following formula.

`=C4>AVERAGE(D4,E4)`

**AVERAGE**function calculates the average of the value from

**D4**and

**E4,**and then we are checking whether the

**C4**value is greater than the derived value or not.

➤ From **Format **select the format of your choice to **Highlight **the cell.*To choose the Format follow the explained steps from Method-2*.

Finally, click **OK**.

As a result, It will **Highlight **the cell values of the ** Spring Price** column where it is

**Greater Than**the

**Average**of the

**and**

*Spring Price***column.**

*Winter Price***Practice Section**

I’ve provided a practice sheet to practice the explained methods.

**Conclusion**

In this article, I’ve explained 6 easy and quick ways of Excel to highlight the cell if value is greater than another cell in Excel. These different ways will help you to highlight a cell compared with another cell if the value is greater than. Last but not least if you have any kind of suggestions, ideas, and feedback please feel free to comment down below.