A common task in analysis is highlighting cells based on its value or relative to other cells. Click on the Highlight button to display the formatting form.
Create as many formatting rules as you require to highlight your data.
The following formatting rule types are available.
•format all cells based on their values via data bar
•format all cells based on their values via icon set
•format all cells based on their values via three color scale
•format all cells based on their values via two color scale
oformat only a range of values
•format only duplicate values
oformat only top or bottom ranked values
•format only unique values
•format only values that are above or below average
•use a formula to determine which cells to format