Data Bars
shortest lowest value =8 top 20 percent
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
7 7 7
8 8 8
9 9 9
10 10 10
Color Scales
shortest lowest value =8 top 20 percent
1 1 1
2 2 1
3 3 1
4 4 2
5 5 4
6 6 5
7 7 5
8 8 8
9 9 9
10 10 10
down arrow =8 top 20 percent
1 1
2 1
3 1
4 2
5 3
6 5
7 5
8 8
9 8
10 10
20th percentile
90th percentile
1
1
1
3
4
7
6
8
9
10
20th percentile
80th percentile
1
1
2
2
4
5
5
7
9
10
20th percentile
80th percentile
1
1
1
2
3
5
5
7
8
10
red fill red
text last
text month
containing yesterday
duplicates Eric red fill green fill
red fill red text green text
John John 6/1/2006
Eric Eric 12/7/2011 today()-1
James James #########
John John 5/15/2007
Erica Erica 6/14/2006
JR JR 2/3/2003
Adam Adam 5/12/2006
Josh Josh 6/17/2005
Babe Babe 8/1/2006
Josh Josh 9/2/2005