1- conditional formatting formulas
TRANSCRIPT
-
7/25/2019 1- Conditional Formatting Formulas
1/79
55
3
44
6
55
13
21
66
9
88
-
7/25/2019 1- Conditional Formatting Formulas
2/79
7/2/2016Saturday
7/3/2016Sunday
7/4/2016Monday
7/5/2016Tuesday
7/6/2016###
7/7/2016Thursday
7/8/2016Friday
7/9/2016Saturday
7/10/2016Sunday
7/11/2016Monday
7/12/2016Tuesday
7/13/2016###
7/14/2016Thursday
7/15/2016Friday
7/16/2016Saturday
7/17/2016Sunday
7/18/2016Monday
7/19/2016Tuesday
7/20/2016###
7/21/2016Thursday
7/22/2016Friday
7/23/2016Saturday
7/24/2016Sunday
7/25/2016Monday
7/26/2016Tuesday
7/27/2016###
7/28/2016Thursday
7/29/2016Friday
7/30/2016Saturday
-
7/25/2019 1- Conditional Formatting Formulas
3/79
1
-
7/25/2019 1- Conditional Formatting Formulas
4/79
+,-.
#"!$
%&
'
(# ' (#&%
-
7/25/2019 1- Conditional Formatting Formulas
5/79
&% )*2,145 )*2 '89""76 3+
)*
2,987
*( )*3,021
8,155
-
7/25/2019 1- Conditional Formatting Formulas
6/79
HOM Furniture Sa"es 2010 and 2011
$a%e 6
Date Salesperson Product Region
Monday 03/01/2011&au%hn, Har"on 'a(tain )e*"iner +
Monday 03/01/2011 +oran, )ita Media -roire S
Tuesday 04/01/2011 'hristensen, .i"" aoo nd Ta"e +
### +oran, )ita aoo 'oee Ta"e S###yrd, -sa aoo nd Ta"e S
Friday 07/01/2011 Oen, )oert 'hae"eon 'ou*h S
Saturday 08/01/2011Maynard, Susan aoo nd Ta"e +
Saturday 08/01/2011 +oran, )ita 'hae"eon 'ou*h S
Saturday 08/01/2011 +oran, )ita Media -roire S
Tuesday 11/01/2011 +oran, )ita Media -roire S
Tuesday 11/01/2011 yrd, -sa aoo 'oee Ta"e S
Tuesday 11/01/2011 &au%hn, Har"on Media -roire +
###yrd, -sa aoo 'oee Ta"e S
### 'hristensen, .i"" 'a(tain )e*"iner +
Thursday 13/01/2011 yrd, -sa aoo nd Ta"e S
Thursday 13/01/2011 Maynard, Susan 'hae"eon 'ou*h +
Friday 14/01/2011 u*as, .ohn 'a(tain )e*"iner S
Friday 14/01/2011Oen, )oert aoo 'oee Ta"e S
###&au%hn, Har"on Media -roire +
Thursday 20/01/2011 u*as, .ohn aoo nd Ta"e S
Friday 21/01/2011 Oen, )oert Media -roire S
Sunday 23/01/2011 iin%ston, ynette aoo nd Ta"e +
Tuesday 25/01/2011 'hristensen, .i"" 'a(tain )e*"iner +
Tuesday 25/01/2011 'hristensen, .i"" Media -roire +
### iin%ston, ynette Media -roire +
Thursday 27/01/2011 &au%hn, Har"on 'hae"eon 'ou*h +
Thursday 27/01/2011 &au%hn, Har"on 'hae"eon 'ou*h +
-
7/25/2019 1- Conditional Formatting Formulas
7/79
HOM Furniture Sa"es 2010 and 2011
$a%e 7
-
7/25/2019 1- Conditional Formatting Formulas
8/79
HOM Furniture Sa"es 2010 and 2011
$a%e 8
-
7/25/2019 1- Conditional Formatting Formulas
9/79
HOM Furniture Sa"es 2010 and 2011
$a%e 9
-
7/25/2019 1- Conditional Formatting Formulas
10/79
HOM Furniture Sa"es 2010 and 2011
$a%e 10
-
7/25/2019 1- Conditional Formatting Formulas
11/79
HOM Furniture Sa"es 2010 and 2011
$a%e 11
-
7/25/2019 1- Conditional Formatting Formulas
12/79
HOM Furniture Sa"es 2010 and 2011
$a%e 12
-
7/25/2019 1- Conditional Formatting Formulas
13/79
HOM Furniture Sa"es 2010 and 2011
$a%e 13
-
7/25/2019 1- Conditional Formatting Formulas
14/79
HOM Furniture Sa"es 2010 and 2011
$a%e 14
-
7/25/2019 1- Conditional Formatting Formulas
15/79
HOM Furniture Sa"es 2010 and 2011
$a%e 15
-
7/25/2019 1- Conditional Formatting Formulas
16/79
HOM Furniture Sa"es 2010 and 2011
$a%e 16
-
7/25/2019 1- Conditional Formatting Formulas
17/79
HOM Furniture Sa"es 2010 and 2011
$a%e 17
-
7/25/2019 1- Conditional Formatting Formulas
18/79
HOM Furniture Sa"es 2010 and 2011
$a%e 18
-
7/25/2019 1- Conditional Formatting Formulas
19/79
HOM Furniture Sa"es 2010 and 2011
$a%e 19
-
7/25/2019 1- Conditional Formatting Formulas
20/79
HOM Furniture Sa"es 2010 and 2011
$a%e 20
-
7/25/2019 1- Conditional Formatting Formulas
21/79
HOM Furniture Sa"es 2010 and 2011
$a%e 21
-
7/25/2019 1- Conditional Formatting Formulas
22/79
HOM Furniture Sa"es 2010 and 2011
$a%e 22
-
7/25/2019 1- Conditional Formatting Formulas
23/79
HOM Furniture Sa"es 2010 and 2011
$a%e 23
-
7/25/2019 1- Conditional Formatting Formulas
24/79
HOM Furniture Sa"es 2010 and 2011
$a%e 24
-
7/25/2019 1- Conditional Formatting Formulas
25/79
HOM Furniture Sa"es 2010 and 2011
$a%e 25
-
7/25/2019 1- Conditional Formatting Formulas
26/79
HOM Furniture Sa"es 2010 and 2011
$a%e 26
-
7/25/2019 1- Conditional Formatting Formulas
27/79
HOM Furniture Sa"es 2010 and 2011
$a%e 27
-
7/25/2019 1- Conditional Formatting Formulas
28/79
HOM Furniture Sa"es 2010 and 2011
$a%e 28
-
7/25/2019 1- Conditional Formatting Formulas
29/79
HOM Furniture Sa"es 2010 and 2011
$a%e 29
Customer Item Cost No.Items Total Cost
S(a*es 34095 9 3,06855
Hoe S- 34095 2 68190
""in%ton :esi%ns 7999 7 55993
""in%ton :esi%ns 16895 3 50685 S(a*es 7999 12 95988
""in%ton :esi%ns 79995 13 10,39935
Hoe S- 7999 10 79990
Hoe S- 79995 2 1,59990
Hoe S- 34095 6 2,04570
S(a*es 34095 13 4,43235
Hoe S- 16895 10 1,68950
Hoe S- 34095 4 1,36380
S(a*es 16895 11 1,85845
S(a*es 34095 7 2,38665
""in%ton :esi%ns 7999 11 87989
S(a*es 79995 6 4,79970
S(a*es 34095 14 4,77330
Hoe S- 16895 10 1,68950
""in%ton :esi%ns 34095 4 1,36380
S(a*es 7999 20 1,59980
Hoe S- 34095 8 2,72760
Hoe S- 7999 11 87989
""in%ton :esi%ns 34095 13 4,43235
S(a*es 34095 7 2,38665
S(a*es 34095 8 2,72760
""in%ton :esi%ns 79995 10 7,99950
Hoe S- 79995 7 5,59965
-
7/25/2019 1- Conditional Formatting Formulas
30/79
HOM Furniture Sa"es 2010 and 2011
$a%e 30
-
7/25/2019 1- Conditional Formatting Formulas
31/79
HOM Furniture Sa"es 2010 and 2011
$a%e 31
-
7/25/2019 1- Conditional Formatting Formulas
32/79
HOM Furniture Sa"es 2010 and 2011
$a%e 32
-
7/25/2019 1- Conditional Formatting Formulas
33/79
HOM Furniture Sa"es 2010 and 2011
$a%e 33
-
7/25/2019 1- Conditional Formatting Formulas
34/79
HOM Furniture Sa"es 2010 and 2011
$a%e 34
-
7/25/2019 1- Conditional Formatting Formulas
35/79
HOM Furniture Sa"es 2010 and 2011
$a%e 35
-
7/25/2019 1- Conditional Formatting Formulas
36/79
HOM Furniture Sa"es 2010 and 2011
$a%e 36
-
7/25/2019 1- Conditional Formatting Formulas
37/79
HOM Furniture Sa"es 2010 and 2011
$a%e 37
-
7/25/2019 1- Conditional Formatting Formulas
38/79
HOM Furniture Sa"es 2010 and 2011
$a%e 38
-
7/25/2019 1- Conditional Formatting Formulas
39/79
HOM Furniture Sa"es 2010 and 2011
$a%e 39
-
7/25/2019 1- Conditional Formatting Formulas
40/79
HOM Furniture Sa"es 2010 and 2011
$a%e 40
-
7/25/2019 1- Conditional Formatting Formulas
41/79
HOM Furniture Sa"es 2010 and 2011
$a%e 41
-
7/25/2019 1- Conditional Formatting Formulas
42/79
HOM Furniture Sa"es 2010 and 2011
$a%e 42
-
7/25/2019 1- Conditional Formatting Formulas
43/79
HOM Furniture Sa"es 2010 and 2011
$a%e 43
-
7/25/2019 1- Conditional Formatting Formulas
44/79
HOM Furniture Sa"es 2010 and 2011
$a%e 44
-
7/25/2019 1- Conditional Formatting Formulas
45/79
HOM Furniture Sa"es 2010 and 2011
$a%e 45
-
7/25/2019 1- Conditional Formatting Formulas
46/79
HOM Furniture Sa"es 2010 and 2011
$a%e 46
-
7/25/2019 1- Conditional Formatting Formulas
47/79
HOM Furniture Sa"es 2010 and 2011
$a%e 47
-
7/25/2019 1- Conditional Formatting Formulas
48/79
HOM Furniture Sa"es 2010 and 2011
$a%e 48
-
7/25/2019 1- Conditional Formatting Formulas
49/79
HOM Furniture Sa"es 2010 and 2011
$a%e 49
-
7/25/2019 1- Conditional Formatting Formulas
50/79
HOM Furniture Sa"es 2010 and 2011
$a%e 50
-
7/25/2019 1- Conditional Formatting Formulas
51/79
HOM Furniture Sa"es 2010 and 2011
$a%e 51
-
7/25/2019 1- Conditional Formatting Formulas
52/79
HOM Furniture Sa"es 2010 and 2011
$a%e 52
-
7/25/2019 1- Conditional Formatting Formulas
53/79
HOM Furniture Sa"es 2010 and 2011
$a%e 53
-
7/25/2019 1- Conditional Formatting Formulas
54/79
HOM Furniture Sa"es 2010 and 2011
$a%e 54
-
7/25/2019 1- Conditional Formatting Formulas
55/79
HOM Furniture Sa"es 2010 and 2011
$a%e 55
-
7/25/2019 1- Conditional Formatting Formulas
56/79
HOM Furniture Sa"es 2010 and 2011
$a%e 56
-
7/25/2019 1- Conditional Formatting Formulas
57/79
HOM Furniture Sa"es 2010 and 2011
$a%e 57
-
7/25/2019 1- Conditional Formatting Formulas
58/79
HOM Furniture Sa"es 2010 and 2011
$a%e 58
-
7/25/2019 1- Conditional Formatting Formulas
59/79
HOM Furniture Sa"es 2010 and 2011
$a%e 59
-
7/25/2019 1- Conditional Formatting Formulas
60/79
HOM Furniture Sa"es 2010 and 2011
$a%e 60
-
7/25/2019 1- Conditional Formatting Formulas
61/79
HOM Furniture Sa"es 2010 and 2011
$a%e 61
-
7/25/2019 1- Conditional Formatting Formulas
62/79
HOM Furniture Sa"es 2010 and 2011
$a%e 62
-
7/25/2019 1- Conditional Formatting Formulas
63/79
HOM Furniture Sa"es 2010 and 2011
$a%e 63
-
7/25/2019 1- Conditional Formatting Formulas
64/79
HOM Furniture Sa"es 2010 and 2011
$a%e 64
-
7/25/2019 1- Conditional Formatting Formulas
65/79
HOM Furniture Sa"es 2010 and 2011
$a%e 65
-
7/25/2019 1- Conditional Formatting Formulas
66/79
HOM Furniture Sa"es 2010 and 2011
$a%e 66
-
7/25/2019 1- Conditional Formatting Formulas
67/79
HOM Furniture Sa"es 2010 and 2011
$a%e 67
-
7/25/2019 1- Conditional Formatting Formulas
68/79
HOM Furniture Sa"es 2010 and 2011
$a%e 68
-
7/25/2019 1- Conditional Formatting Formulas
69/79
HOM Furniture Sa"es 2010 and 2011
$a%e 69
-
7/25/2019 1- Conditional Formatting Formulas
70/79
HOM Furniture Sa"es 2010 and 2011
$a%e 70
-
7/25/2019 1- Conditional Formatting Formulas
71/79
HOM Furniture Sa"es 2010 and 2011
$a%e 71
-
7/25/2019 1- Conditional Formatting Formulas
72/79
HOM Furniture Sa"es 2010 and 2011
$a%e 72
-
7/25/2019 1- Conditional Formatting Formulas
73/79
HOM Furniture Sa"es 2010 and 2011
$a%e 73
-
7/25/2019 1- Conditional Formatting Formulas
74/79
HOM Furniture Sa"es 2010 and 2011
$a%e 74
-
7/25/2019 1- Conditional Formatting Formulas
75/79
A
-"an ;i""in%haTay $hi"(otendy auer
Mary )e(ass'"audette .uares
.eanne 'oseMaureen S Hudson-y ron
Mary :ai"ey"iinstry;era"d Tru@i""oSte(hen . ;ua@ardo
u*i""e H $a*>-n%e" ' eos&e"a Fin*her
.enni?er Ma*hen;re%ory :ais-rando Tay"or
:ana i"son.ason $a"ieri)andy : $hi""i(s
Aaren $ier*e)ay B erette"yn M*danie"
;ordon eaer$asCua"e &a"en
-
7/25/2019 1- Conditional Formatting Formulas
76/79
:iane i""is:aid MartinFran> M*u""an
.ose(h $ar>s.aes ;entryi""ie $oers
:aid . o"eyMary n%"and'har"es ;re%%
:aid F"oersMarin H M*Cui""en=sidro .ensen
Fran*is*o "der&io"et ee'hristo(her reer
Thoas -ri@o'har"ie Stine-ndre F"ores
;re%ory )eeseTi E oery:oris Hoe
.ean S*haauren )osa-nna ;oodin
Sarah -"onso$au" Mar>s:e"ia are
:ona"d :ehaenHattie Herrera:onna M Forehand
Santos H $urdiei""ia Hartens
Mary Star>s.oe M*ray-"a 'randa""
)i*o '"ar>e)ayond Sears)on Torres
;"enn A Mo"ina'atherine SaoyMyrtie -d*o*>
;ary oyd'hristine ;ri@a"aryan Ma
)o%er AhouryMe"anie ardMatthe 'oart
aerne . StinsonTerry Muni
-
7/25/2019 1- Conditional Formatting Formulas
77/79
i"a areau
Harry ood
'"iord : Sith
Tiothy = Sheeran
Mi*hae" uan>
-"?one
Mario Sherer
$au" Hai"ton
.erey arnes
-ndre ;ordon
Aathryn i""ia
-n%e"a Martin
'"aude us*h
.ose ays
-" Hoan
.aes ;osha
u%ene ashurn
)ee**a :ais
Aathy 'hi"dress
.aes E +eton
'ar" Ho((er
Mar* ao
Martha Doun%
Tony M 'han
.enni?er ood
:ere> ;"aser
-
7/25/2019 1- Conditional Formatting Formulas
78/79
>90
41916285574356
7566383517131539
90480714121896
216188369504777
968437379611288
928051398488585
257697155361213
62388852555166
1270383835409496
2089146592962740
8054179177311875
2125346929848820
795237639733724
4141726496715762
4871753259447412
6110059942717880
867826189516287
867527458371399
14581002491348050
2154324649707830
6117586229914118
642408677229246
9840921555926748
469544288878611
43656921647156
5213113463179092
233699331791478
3019756935391560
--->,- ( 0
-
7/25/2019 1- Conditional Formatting Formulas
79/79
174518680100278
1339751843855662
33213286346741
9011877150219986
897645429787471
733592689579730
3413691169339987
7946501454678650
2399803966641687
7223812913592443
6943735117501712
936285935867368
464002050623367
5654643859217359
506148984974289
8741878676394864
418439994916674
9263742911499781
6986749836454219
831243517665217
7306747669410018
5688912895459481
785292176366294
171836435206629
6496240100597462
849100372140471
5999184732334715
8656199664791952