Excel conditional formatting lets you customize cells of a spreadsheet, depending on the data. That way, you can highlight important data, through rules defined by you.
If the conditional formatting is not enough, you can also use the “Excel” functions that allow you to add several “conditions”. For more details see the following tutorial: If Excel Formula.
Conditional formatting in Excel
Excel puts at your disposal various types of data and formatting rules ready to use. To get started, simply select the data that you want to use and access the menu-Based conditional formatting.
For example, imagine that you want to enhance the “green” all sales above 1000 dollars. To do this, start by selecting the cells containing the values you will use, and go to the tab “Basis”-conditional formatting Highlight cells rules-“greater than”. Finally, set the fill color to “green”.
How to use conditional formatting in Excel
You can also create other rules to compare values “less than”, “between”, “equal”, etc.
Data bar: Start by selecting the data you want to use in formatting. Go to Menu-Based conditional formatting-color bar. Finally, select the gradation of colors you want to use.
Another interesting option of conditional formatting are the icon sets, which allow a quick analysis of the data.
For example, start by selecting the data you want to use and access the menu “base-conditional formatting-set of icons.
Select the type of icons that will use. For example, the lights represent the values of a fairly simple:
Green: higher values;
Yellow: intermediate Values;
Red: lower values.