#Conditional formatting excel 2016 table how to#
Normally, the data can be visually differentiated using one or more rules, however, in this article, we will discuss how to apply conditional formatting with 2 conditions.įigure 1 – Final result 1 Column, 2 Rules, 2 Conditions The conditional formatting is used to create visual differentiation in a large set of data, in some standard format. Now when you return to the spreadsheet, you should see that Jody has the highest score of 10 which is highlighted in green.Ĭongratulations, you have learned how to use conditional formatting to highlight the top value in an Excel table.How Do You Do Conditional Formatting with 2 Conditions? As a general rule, we like to uncheck the "Stop If True" checkbox in case we want to add more conditional formatting rules later.Ĭlick on the OK button to close the Conditional Formatting Rules Manager and apply our new rules. This will return you to the Conditional Formatting Rules Manager window. In this example, the Preview box shows light green as the fill color. When you return to the New Formatting Rule window, you should see the preview of the formatting in the Preview box. In this example, we've selected light green. Then select the background color that you'd like to see for the highest score. When the Format Cells window appears, select the Fill tab. Next, we need to select what formatting to apply when this condition is met. Then select Top in the first drop down and enter 1 in the text box next to it. When the New Formatting Rule window appears, select Format only top or bottom ranked values as the rule type.
When the Conditional Formatting Rules Manager window appears, click on the "New Rule" button. Then in the Styles group, click on the Conditional Formatting drop-down and select Manage Rules. Select the Home tab in the toolbar at the top of the screen.
In this example, we've selected cells B2:B11. To highlight the top score in Excel 2016, you will need to do the following steps:įirst highlight the range of cells that you want to apply the formatting to.
#Conditional formatting excel 2016 table download#
If you want to follow along with this tutorial, download the example spreadsheet.ĭownload Example Steps to Highlight the Top Score (or Value) in an Excel Table