Highlighting cells

Top  Previous  Next

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.

 

highlight_01

 

 

Create as many formatting rules as you require to highlight your data.

 

highlight_03

 

 

The following formatting rule types are available.

 

highlight_04

 

 

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