Conditional Formatting in Excel

conditional formatting excel
Excel Spreadsheets

In times of quick information, variety of data and the need to find them quickly and quickly, the possibility of visual monitoring makes it easier day by day. Excel has several ways to facilitate the routine of a company, business or even personal life. Among them is Conditional Formatting in Excel.

Excel Online Course

With it, Excel can analyze and identify certain content and automatically apply the color, font, and border that you have chosen. Why? Let's imagine you have a spreadsheet filled with complex data and one day you need to find a little detail inside it. In a spreadsheet of one color and all the same, this data can be mixed and you will be slow to find it.

unconditional spreadsheet

Already with conditional formatting, this data will be in a specific color, ie if within the spreadsheet there are 10 cells that contain what you are looking for, the 10 cells will be highlighted in the color you have chosen, making them easier to find and obtain the necessary data.

worksheet with conditional formatting

Example: you have an indicator that targets the 35 value. You can format it by asking that if the goal is met 50%, the cell turns blue, if it is 30%, the cell turns yellow and if 10% the cell turns red. That way, you indicate how the analysis will be done in the formatting and it will automatically do it, see how it will make everyday easier?

How Formatting Happens

The cells that will undergo this formatting are selected and then clicked on the start page, style, and conditional formatting. Several places will appear offering some options to highlight the values. Have the items:

  • Data Bars;
  • Color Scales;
  • Sets of Icons.

If the highlight is done in the color scale, simply choose the "color scale" item and hover over each of the options to preview the effect before applying it. When you find the most interesting, click on it.

After that it is necessary to go to the formatting style and define the minimum and maximum values ​​and what colors will be used to highlight them. If after the spreadsheet is ready you are going to use it and do not like the result, it is possible to change it without difficulty. Just click on “Conditional Formatting” and click on “Manage Rules”.

In addition to the formatting used, you can apply the "Data Bars" and "Icon Sets" options in the same way as the previous one.

Excel Online Course

Applying this formatting


You can use this type of formatting to emphasize data from a productivity table by using a color to highlight the above values ​​and others to the values ​​below. You can also use it to highlight the average productivity of a given company sector, increase or decrease the sales of a particular product in your store, or even the financial flow of a particular department.

This formatting gives a more visually accessible air to the most varied data and becomes a great ally of those who want agility and practicality when it comes to finding it.

Excel Online Course

Are you interested? Contact us and order the spreadsheet with this formatting made especially for you! 

Excel Spreadsheets


Please, write your comment
Please enter your name