How Can The Conditional Format Help You in Excel?

7.9 min read|Last Updated: May 5th, 2022|Categories: excel|
table of content

If you have created an important, but lengthy Excel sheet, containing lots of information, it might be hard to find the data you want. For example, you may need to analyze your sales and find the values that are higher or less than a certain amount. That’s only one of the scenarios that conditional formatting in Excel can solve. Therefore, learning what it is and how it works can be of considerable help when working with Excel.

Conditional Formatting in Excel: Highlight Cells Rules

You can use conditional formatting in Excel to highlight numbers that are higher, less than a number, or even between two numbers. It’s so simple. Just start by choosing the table or columns that you want to find your preferred values in.

Highlight numbers that are higher than X 

 In our example, we want to find values that are higher than 15000. 

  1. From the “Home” tab Click on “Conditional Formatting” in the “Styles” group. 
  2. When the menu opens, click on “Highlight Cells Rules” and choose “Greater Than”.
Conditional formatting in Excel, Highlighting values that are higher than an specific amount
Figure 1- Highlighting values that are higher than an amount.
  1. Now you can choose the value you want to analyze your data based on it. In our example, we have chosen 15000. 
  2. We also want to highlight the numbers in red, which you can change from the drop-down menu in front of the number field. 
  3. You can see that all the cells that have values greater than 15000 turn red.