This will open the Value Field Settings dialogue box:  The  Values  field will change to the selected calculation. Conditional formatting allows you to change the appearance of a cell, based on criteria that you define,  using predetermined rules in Excel. Using the highlight cells rules, you can highlight cells in your data that are greater or less than a value,  between or equal to a value or contain a specified or duplicate value. To highlight cells which contain data greater than a specific value:  3. Choose the calculation you want to summarize. 4. Click  Ok .  1. Highlight the data range. 2. Select the  Conditional Formatting  tool  3. Hover over  Highlight Cells Rules  to reveal the menu of different rules. 14  Greater Than  Highlight Cells Rules  Conditional Formatting 