Click on the Quick Analysis button then on the button Text That Contains: The Quick Analysis button appears at the bottom of the selection.
Suppose we want to show the inhabitant cases at Charlwood Street. Notice that cell B4 automatically turns red:Ĭonsider the following spreadsheet extract: Modify a value for example, at line 4, put the value 2200 and validate with the Enter key on the keyboard. In the Less Than dialog box, enter the value 4000 and select Light Red Fill with Dark Red Text: Select the range B2: B14 again and click the Conditional Formatting command on the Home tab of the ribbon, choose Highlight Cells Rules, then choose Less Than: In the Between dialog box, enter the value 4000, the value 8000 and select Yellow Fill with Dark Yellow Text: Keep the range B2:B14 selected and click the Conditional Formatting command on the Home tab of the ribbon, choose Highlight Cells Rules, then choose Between: In the Greater Than dialog box that appears, enter the value 8000 and select Green Fill with Dark Green Text: Select the range B2:B14 and click on the Conditional Formatting command on the Home tab of the ribbon, choose Highlight Cells Rules, then choose Greater Than:
Let's apply some formatting for the values in column B as follows: Values less than, greater than, betweenĬonsider the following excerpt from a spreadsheet: Other conditional formatting commands are available from the Conditional Formatting command in the Styles group on the Home tab of the ribbon. If the selected cells contain numbers, the options that appear are: If the selected cells contain only text, the options that appear are: at the lower right corner of the selection:Ĭlick on the Quick Analysis button, to see conditional formatting options. This button, introduced from the 2013 version of Excel, appears as soon as you select a range of cells. Next, we will see a multitude of real-life examples of conditional formatting. We are going to give you an overview of this Quick Analysis button. Either the Conditional Formatting command from the Home tab of the ribbon.To define conditional formatting, we will use: This has the advantage of highlighting cells that meet certain criteria or showing variations or trends.Ī great advantage with this technique is that after defining conditional formatting, Excel automatically updates the formatting, every time you make updates at your sheet. Conditional formatting allows you to define a formatting (essentially font or background colors of cells, etc.) that will be applied to cells meeting a condition.