Excel Highlight Cell If Value Greater Than Another Cell (6 Ways)

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 Winter Price. Here, I will show you in which season the price is greater than from other seasons.

Sample Dataset

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

Using Greater Than From Ribbon to Highlight Cell If Value Greater Than Another Cell 

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

Using Greater Than From Ribbon to Highlight Cell If Value Greater Than Another Cell 

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 Summer Price columns.

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

Using Greater Than Equal (>=) Operator to Excel Highlight Cell Greater Than Another Cell

➤ 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
Now, click on Format to select the format of your choice to 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.

Using Greater Than (>) Operator to Highlight Cell If Value Greater Than Another Cell

Then, click OK.

Using Greater Than Equal (>=) Operator to Excel Highlight Cell Greater Than Another Cell

In the end, click OK.
Therefore, It will Highlight the cell values of the Spring Price column where it is Greater Than the Summer Price column.

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 Winter Price columns.

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

Using Greater Than Equal (>=) Operator to Excel Highlight Cell Greater Than Another Cell

➤ 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 Winter Price column.

Using Greater Than Equal (>=) Operator to Highlight Cell If Value Greater Than Another Cell


Similar Readings:


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.

Using Greater Than Equal (>) For Blank Cell to Excel Highlight Cell Greater Than Another Cell

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

Using Greater Than Equal (>) For Blank Cell to Excel Highlight Cell Greater Than Another Cell

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

 

Using Greater Than Equal (>) For Blank Cell to Highlight Cell If Value Greater Than Another Cell

Finally, click OK.
Hence, It will Highlight the cell values of the Summer Price column where it is Greater Than the Winter Price column, but you will see that the values that would be compared to the Blank Cells values are not Highlighted as we skipped the Blank Cells using $E4<>”” within the formula.

Using Greater Than Equal (>) For Blank Cell to Excel Highlight Cell Greater Than Another Cell

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 Winter Price columns.

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

Using IF to Excel Highlight Cell Greater Than Another Cell

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

=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 Winter Price column.

Using IF to Excel Highlight Cell Greater Than Another Cell

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 Winter Price column and will check whether the Spring Price column is 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

Using Average to Excel Highlight Cell If Value Greater Than Another Cell

➤ 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>AVERAGE(D4,E4)
Here, the 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 Spring Price and Winter Price column.

Using Average to Excel Highlight Cell If Value Greater Than Another Cell

Practice Section

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

Practice Excel Highlight Cell If Value Greater Than Another Cell

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.


Further Readings

Shamima

Shamima

Hello! Welcome to my Profile. I am Shamima Sultana Rita. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Computer Science and Engineering from East West University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. I love to learn new things. Data Analysis is one of my favorite fields as I love to extract patterns based on problems. Here, I'm trying to provide enriched quality content regarding Excel basics to Advanced. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo