content_image/786237.jpg content_image/786249.jpg
This will open the Value Field Settings dialogue box: 

<img src='content_image/786237.jpg'>

3. Choose the calculation you want to summarize. 

4. Click Ok . 

The Values  field will change to the selected calculation. 

## Conditional Formatting 

Conditional formatting allows you to change the appearance of a cell, based on criteria that you define, using predetermined rules in Excel. 

## Highlight Cells Rules 

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. 

## Greater Than 

To highlight cells which contain data greater than a specific value: 

1. Highlight the data range. 

2. Select the Conditional Formatting  tool 

<img src='content_image/786249.jpg'>

3. Hover over Highlight Cells Rules  to reveal the menu of different rules. 

