A box will appear which will offer you two options.Go to Home tab > Conditional formatting button > Highlight Cell Rules option > Greater Than….As we want to format the Quantity column, so we select it. Select the cell range that you want to format.We will highlight cells with red color where Quantity is greater than 20. To begin our tutorial, first we will apply a simple rule. On the Home tab, go to Conditional Formatting menu and then under Highlight Cell Rules option you will see several pre-built rules that you can use: If you want to highlight certain cells based on a condition, the Highlight Cell Rules come very handy.

The worksheet contains sample data of an order processing unit and this is how it looks like:Ĭonditional Formatting: Highlight Cell Rules You can download the Excel sample worksheet that we will use for the tutorial. In this tutorial, we will learn what is conditional formatting and how to use it to format cells on the basis of a condition. We have recently published articles on other data analysis features like VLOOKUP and Pivot Tables. It helps us in better understanding and analyzing the data. Excel will apply this formatting on the cells whose values will match the set condition.Ĭonditional Formatting is yet another Excel feature that helps us in data visualization. We can set both the conditional formula and formatting. Conditional Formatting is a Microsoft Excel feature that allows us to change appearance of cells on the basis of a defined condition.

Excel income and expense template free