WEBVTT
Kind: captions
Language: en

00:00:06.799 --> 00:00:09.770 align:start position:0%
 
imagine<00:00:07.799><c> you</c><00:00:07.919><c> have</c><00:00:08.099><c> a</c><00:00:08.130><c> spreadsheets</c><00:00:08.910><c> with</c><00:00:09.150><c> 500</c>

00:00:09.770 --> 00:00:09.780 align:start position:0%
imagine you have a spreadsheets with 500
 

00:00:09.780 --> 00:00:12.770 align:start position:0%
imagine you have a spreadsheets with 500
plus<00:00:10.050><c> rows</c><00:00:10.500><c> of</c><00:00:10.769><c> data</c><00:00:11.010><c> it's</c><00:00:11.940><c> hard</c><00:00:12.360><c> if</c><00:00:12.719><c> not</c>

00:00:12.770 --> 00:00:12.780 align:start position:0%
plus rows of data it's hard if not
 

00:00:12.780 --> 00:00:15.499 align:start position:0%
plus rows of data it's hard if not
impossible<00:00:13.049><c> to</c><00:00:13.980><c> see</c><00:00:14.250><c> patterns</c><00:00:14.580><c> and</c><00:00:14.910><c> trends</c><00:00:15.240><c> in</c>

00:00:15.499 --> 00:00:15.509 align:start position:0%
impossible to see patterns and trends in
 

00:00:15.509 --> 00:00:18.470 align:start position:0%
impossible to see patterns and trends in
the<00:00:15.630><c> data</c><00:00:16.220><c> even</c><00:00:17.220><c> with</c><00:00:17.369><c> similar</c><00:00:17.789><c> spreadsheets</c>

00:00:18.470 --> 00:00:18.480 align:start position:0%
the data even with similar spreadsheets
 

00:00:18.480 --> 00:00:20.480 align:start position:0%
the data even with similar spreadsheets
it<00:00:18.750><c> can</c><00:00:18.960><c> be</c><00:00:19.050><c> difficult</c><00:00:19.619><c> to</c><00:00:19.650><c> spot</c><00:00:19.949><c> patterns</c>

00:00:20.480 --> 00:00:20.490 align:start position:0%
it can be difficult to spot patterns
 

00:00:20.490 --> 00:00:23.840 align:start position:0%
it can be difficult to spot patterns
with<00:00:20.789><c> row</c><00:00:21.060><c> after</c><00:00:21.359><c> row</c><00:00:21.600><c> of</c><00:00:22.170><c> data</c><00:00:22.380><c> an</c><00:00:22.850><c> Excel</c>

00:00:23.840 --> 00:00:23.850 align:start position:0%
with row after row of data an Excel
 

00:00:23.850 --> 00:00:25.910 align:start position:0%
with row after row of data an Excel
feature<00:00:24.300><c> called</c><00:00:24.720><c> conditional</c><00:00:25.439><c> formatting</c>

00:00:25.910 --> 00:00:25.920 align:start position:0%
feature called conditional formatting
 

00:00:25.920 --> 00:00:28.609 align:start position:0%
feature called conditional formatting
can<00:00:26.220><c> help</c><00:00:26.460><c> with</c><00:00:26.640><c> this</c><00:00:27.019><c> with</c><00:00:28.019><c> conditional</c>

00:00:28.609 --> 00:00:28.619 align:start position:0%
can help with this with conditional
 

00:00:28.619 --> 00:00:31.040 align:start position:0%
can help with this with conditional
formatting<00:00:29.099><c> you</c><00:00:29.760><c> can</c><00:00:29.939><c> apply</c><00:00:30.210><c> formatting</c><00:00:30.900><c> to</c>

00:00:31.040 --> 00:00:31.050 align:start position:0%
formatting you can apply formatting to
 

00:00:31.050 --> 00:00:34.130 align:start position:0%
formatting you can apply formatting to
one<00:00:31.320><c> or</c><00:00:31.619><c> more</c><00:00:32.009><c> cells</c><00:00:32.399><c> based</c><00:00:33.270><c> on</c><00:00:33.540><c> the</c><00:00:33.630><c> value</c><00:00:34.110><c> of</c>

00:00:34.130 --> 00:00:34.140 align:start position:0%
one or more cells based on the value of
 

00:00:34.140 --> 00:00:36.920 align:start position:0%
one or more cells based on the value of
the<00:00:34.500><c> cell</c><00:00:34.739><c> you</c><00:00:35.100><c> can</c><00:00:36.000><c> highlight</c><00:00:36.360><c> interesting</c>

00:00:36.920 --> 00:00:36.930 align:start position:0%
the cell you can highlight interesting
 

00:00:36.930 --> 00:00:40.790 align:start position:0%
the cell you can highlight interesting
or<00:00:37.440><c> unusual</c><00:00:37.800><c> cell</c><00:00:38.520><c> values</c><00:00:39.059><c> and</c><00:00:39.780><c> visualize</c><00:00:40.559><c> the</c>

00:00:40.790 --> 00:00:40.800 align:start position:0%
or unusual cell values and visualize the
 

00:00:40.800 --> 00:00:44.770 align:start position:0%
or unusual cell values and visualize the
data<00:00:41.040><c> using</c><00:00:41.340><c> formatting</c><00:00:42.030><c> such</c><00:00:42.300><c> as</c><00:00:42.480><c> data</c><00:00:42.719><c> bars</c>

00:00:44.770 --> 00:00:44.780 align:start position:0%
data using formatting such as data bars
 

00:00:44.780 --> 00:00:47.479 align:start position:0%
data using formatting such as data bars
let's<00:00:45.780><c> take</c><00:00:46.079><c> a</c><00:00:46.110><c> look</c><00:00:46.440><c> at</c><00:00:46.559><c> how</c><00:00:46.739><c> we</c><00:00:46.800><c> can</c><00:00:47.309><c> use</c>

00:00:47.479 --> 00:00:47.489 align:start position:0%
let's take a look at how we can use
 

00:00:47.489 --> 00:00:49.369 align:start position:0%
let's take a look at how we can use
conditional<00:00:47.700><c> formatting</c><00:00:48.059><c> in</c><00:00:48.750><c> our</c><00:00:48.870><c> company</c>

00:00:49.369 --> 00:00:49.379 align:start position:0%
conditional formatting in our company
 

00:00:49.379 --> 00:00:54.229 align:start position:0%
conditional formatting in our company
cells<00:00:49.649><c> spreadsheet</c><00:00:51.800><c> first</c><00:00:52.800><c> select</c><00:00:53.100><c> an</c><00:00:53.969><c> area</c>

00:00:54.229 --> 00:00:54.239 align:start position:0%
cells spreadsheet first select an area
 

00:00:54.239 --> 00:00:57.470 align:start position:0%
cells spreadsheet first select an area
that<00:00:54.570><c> you'd</c><00:00:54.780><c> like</c><00:00:54.989><c> to</c><00:00:55.199><c> highlight</c><00:00:55.910><c> our</c><00:00:56.910><c> order</c>

00:00:57.470 --> 00:00:57.480 align:start position:0%
that you'd like to highlight our order
 

00:00:57.480 --> 00:00:59.090 align:start position:0%
that you'd like to highlight our order
amounts<00:00:58.109><c> are</c><00:00:58.260><c> really</c><00:00:58.620><c> what</c><00:00:58.829><c> we</c><00:00:58.949><c> would</c>

00:00:59.090 --> 00:00:59.100 align:start position:0%
amounts are really what we would
 

00:00:59.100 --> 00:01:00.860 align:start position:0%
amounts are really what we would
probably<00:00:59.340><c> want</c><00:00:59.879><c> to</c><00:00:59.940><c> apply</c><00:01:00.270><c> conditional</c>

00:01:00.860 --> 00:01:00.870 align:start position:0%
probably want to apply conditional
 

00:01:00.870 --> 00:01:04.189 align:start position:0%
probably want to apply conditional
formatting<00:01:00.930><c> to</c><00:01:01.649><c> on</c><00:01:01.920><c> the</c><00:01:02.460><c> Home</c><00:01:02.699><c> tab</c><00:01:03.049><c> locate</c><00:01:04.049><c> the</c>

00:01:04.189 --> 00:01:04.199 align:start position:0%
formatting to on the Home tab locate the
 

00:01:04.199 --> 00:01:08.990 align:start position:0%
formatting to on the Home tab locate the
Styles<00:01:04.650><c> group</c><00:01:07.189><c> click</c><00:01:08.189><c> the</c><00:01:08.250><c> conditional</c>

00:01:08.990 --> 00:01:09.000 align:start position:0%
Styles group click the conditional
 

00:01:09.000 --> 00:01:10.940 align:start position:0%
Styles group click the conditional
formatting<00:01:09.049><c> commands</c><00:01:10.049><c> and</c><00:01:10.320><c> a</c><00:01:10.380><c> menu</c><00:01:10.770><c> will</c>

00:01:10.940 --> 00:01:10.950 align:start position:0%
formatting commands and a menu will
 

00:01:10.950 --> 00:01:12.920 align:start position:0%
formatting commands and a menu will
appear<00:01:11.040><c> with</c><00:01:11.790><c> your</c><00:01:11.820><c> formatting</c><00:01:12.450><c> options</c>

00:01:12.920 --> 00:01:12.930 align:start position:0%
appear with your formatting options
 

00:01:12.930 --> 00:01:15.289 align:start position:0%
appear with your formatting options
let's<00:01:13.590><c> take</c><00:01:13.860><c> a</c><00:01:13.890><c> look</c><00:01:14.220><c> at</c><00:01:14.369><c> how</c><00:01:14.549><c> a</c><00:01:14.580><c> few</c><00:01:15.060><c> of</c><00:01:15.180><c> these</c>

00:01:15.289 --> 00:01:15.299 align:start position:0%
let's take a look at how a few of these
 

00:01:15.299 --> 00:01:19.179 align:start position:0%
let's take a look at how a few of these
work<00:01:15.689><c> the</c><00:01:16.680><c> first</c><00:01:17.009><c> one</c><00:01:17.330><c> highlight</c><00:01:18.330><c> cell</c><00:01:18.659><c> rules</c>

00:01:19.179 --> 00:01:19.189 align:start position:0%
work the first one highlight cell rules
 

00:01:19.189 --> 00:01:22.899 align:start position:0%
work the first one highlight cell rules
such<00:01:20.189><c> as</c><00:01:20.220><c> greater</c><00:01:20.909><c> than</c><00:01:21.240><c> and</c><00:01:21.570><c> less</c><00:01:21.600><c> than</c>

00:01:22.899 --> 00:01:22.909 align:start position:0%
such as greater than and less than
 

00:01:22.909 --> 00:01:25.609 align:start position:0%
such as greater than and less than
let's<00:01:23.909><c> choose</c><00:01:24.210><c> less</c><00:01:24.570><c> than</c><00:01:24.900><c> and</c><00:01:25.229><c> apply</c>

00:01:25.609 --> 00:01:25.619 align:start position:0%
let's choose less than and apply
 

00:01:25.619 --> 00:01:27.859 align:start position:0%
let's choose less than and apply
formatting<00:01:26.130><c> to</c><00:01:26.369><c> cells</c><00:01:26.400><c> with</c><00:01:26.970><c> values</c><00:01:27.450><c> less</c>

00:01:27.859 --> 00:01:27.869 align:start position:0%
formatting to cells with values less
 

00:01:27.869 --> 00:01:31.670 align:start position:0%
formatting to cells with values less
than<00:01:28.110><c> $200</c><00:01:29.150><c> after</c><00:01:30.150><c> entering</c><00:01:30.540><c> the</c><00:01:30.750><c> value</c><00:01:31.140><c> we</c>

00:01:31.670 --> 00:01:31.680 align:start position:0%
than $200 after entering the value we
 

00:01:31.680 --> 00:01:33.620 align:start position:0%
than $200 after entering the value we
can<00:01:31.890><c> use</c><00:01:32.100><c> the</c><00:01:32.220><c> drop</c><00:01:32.460><c> down</c><00:01:32.490><c> menu</c><00:01:33.119><c> to</c><00:01:33.150><c> choose</c><00:01:33.450><c> the</c>

00:01:33.620 --> 00:01:33.630 align:start position:0%
can use the drop down menu to choose the
 

00:01:33.630 --> 00:01:36.170 align:start position:0%
can use the drop down menu to choose the
color<00:01:33.960><c> and</c><00:01:34.259><c> type</c><00:01:34.890><c> with</c><00:01:35.130><c> formatting</c><00:01:35.610><c> for</c><00:01:35.850><c> Excel</c>

00:01:36.170 --> 00:01:36.180 align:start position:0%
color and type with formatting for Excel
 

00:01:36.180 --> 00:01:40.840 align:start position:0%
color and type with formatting for Excel
to<00:01:36.390><c> apply</c><00:01:36.689><c> and</c><00:01:37.100><c> then</c><00:01:38.100><c> click</c><00:01:38.159><c> OK</c>

00:01:40.840 --> 00:01:40.850 align:start position:0%
 
 

00:01:40.850 --> 00:01:43.730 align:start position:0%
 
now<00:01:41.850><c> in</c><00:01:42.119><c> the</c><00:01:42.210><c> spreadsheet</c><00:01:42.570><c> the</c><00:01:43.200><c> cells</c><00:01:43.500><c> with</c>

00:01:43.730 --> 00:01:43.740 align:start position:0%
now in the spreadsheet the cells with
 

00:01:43.740 --> 00:01:47.080 align:start position:0%
now in the spreadsheet the cells with
values<00:01:44.159><c> less</c><00:01:44.549><c> than</c><00:01:44.579><c> $200</c><00:01:45.540><c> appear</c><00:01:45.960><c> highlighted</c>

00:01:47.080 --> 00:01:47.090 align:start position:0%
values less than $200 appear highlighted
 

00:01:47.090 --> 00:01:49.999 align:start position:0%
values less than $200 appear highlighted
this<00:01:48.090><c> allows</c><00:01:48.479><c> us</c><00:01:48.509><c> to</c><00:01:48.720><c> easily</c><00:01:48.869><c> identify</c><00:01:49.380><c> the</c>

00:01:49.999 --> 00:01:50.009 align:start position:0%
this allows us to easily identify the
 

00:01:50.009 --> 00:01:56.569 align:start position:0%
this allows us to easily identify the
low<00:01:50.369><c> orders</c><00:01:54.320><c> to</c><00:01:55.320><c> remove</c><00:01:55.680><c> these</c><00:01:55.950><c> formatting</c>

00:01:56.569 --> 00:01:56.579 align:start position:0%
low orders to remove these formatting
 

00:01:56.579 --> 00:01:58.789 align:start position:0%
low orders to remove these formatting
rules<00:01:56.850><c> we'll</c><00:01:57.630><c> just</c><00:01:57.899><c> click</c><00:01:58.110><c> the</c><00:01:58.259><c> conditional</c>

00:01:58.789 --> 00:01:58.799 align:start position:0%
rules we'll just click the conditional
 

00:01:58.799 --> 00:02:01.370 align:start position:0%
rules we'll just click the conditional
formatting<00:01:59.189><c> command</c><00:01:59.700><c> and</c><00:02:00.000><c> select</c><00:02:00.780><c> clear</c>

00:02:01.370 --> 00:02:01.380 align:start position:0%
formatting command and select clear
 

00:02:01.380 --> 00:02:05.179 align:start position:0%
formatting command and select clear
rules<00:02:02.990><c> since</c><00:02:03.990><c> my</c><00:02:04.259><c> cells</c><00:02:04.619><c> aren't</c><00:02:05.040><c> selected</c>

00:02:05.179 --> 00:02:05.189 align:start position:0%
rules since my cells aren't selected
 

00:02:05.189 --> 00:02:07.850 align:start position:0%
rules since my cells aren't selected
right<00:02:05.700><c> now</c><00:02:05.880><c> I'll</c><00:02:06.329><c> just</c><00:02:06.719><c> choose</c><00:02:06.960><c> clear</c><00:02:07.409><c> rules</c>

00:02:07.850 --> 00:02:07.860 align:start position:0%
right now I'll just choose clear rules
 

00:02:07.860 --> 00:02:11.240 align:start position:0%
right now I'll just choose clear rules
from<00:02:08.160><c> entire</c><00:02:08.520><c> worksheet</c><00:02:09.179><c> and</c><00:02:09.920><c> there</c><00:02:10.920><c> you</c><00:02:11.099><c> go</c>

00:02:11.240 --> 00:02:11.250 align:start position:0%
from entire worksheet and there you go
 

00:02:11.250 --> 00:02:13.850 align:start position:0%
from entire worksheet and there you go
the<00:02:11.580><c> formatting</c><00:02:12.090><c> is</c><00:02:12.209><c> removed</c>

00:02:13.850 --> 00:02:13.860 align:start position:0%
the formatting is removed
 

00:02:13.860 --> 00:02:15.080 align:start position:0%
the formatting is removed
take<00:02:14.070><c> a</c><00:02:14.100><c> look</c><00:02:14.370><c> at</c><00:02:14.490><c> some</c><00:02:14.700><c> of</c><00:02:14.820><c> the</c><00:02:14.880><c> other</c>

00:02:15.080 --> 00:02:15.090 align:start position:0%
take a look at some of the other
 

00:02:15.090 --> 00:02:20.410 align:start position:0%
take a look at some of the other
conditional<00:02:15.810><c> formatting</c><00:02:16.200><c> options</c><00:02:19.370><c> besides</c>

00:02:20.410 --> 00:02:20.420 align:start position:0%
conditional formatting options besides
 

00:02:20.420 --> 00:02:22.970 align:start position:0%
conditional formatting options besides
locating<00:02:21.420><c> cells</c><00:02:21.720><c> that</c><00:02:21.960><c> are</c><00:02:22.080><c> greater</c><00:02:22.410><c> than</c><00:02:22.530><c> or</c>

00:02:22.970 --> 00:02:22.980 align:start position:0%
locating cells that are greater than or
 

00:02:22.980 --> 00:02:25.220 align:start position:0%
locating cells that are greater than or
less<00:02:23.010><c> than</c><00:02:23.520><c> a</c><00:02:23.610><c> value</c><00:02:24.060><c> you</c><00:02:24.330><c> can</c><00:02:24.750><c> also</c><00:02:24.960><c> apply</c>

00:02:25.220 --> 00:02:25.230 align:start position:0%
less than a value you can also apply
 

00:02:25.230 --> 00:02:27.440 align:start position:0%
less than a value you can also apply
formatting<00:02:26.040><c> to</c><00:02:26.160><c> cells</c><00:02:26.190><c> that</c><00:02:26.670><c> are</c><00:02:26.820><c> between</c><00:02:26.970><c> two</c>

00:02:27.440 --> 00:02:27.450 align:start position:0%
formatting to cells that are between two
 

00:02:27.450 --> 00:02:30.410 align:start position:0%
formatting to cells that are between two
values<00:02:27.960><c> equal</c><00:02:28.620><c> to</c><00:02:28.650><c> a</c><00:02:28.770><c> value</c><00:02:29.040><c> or</c><00:02:29.760><c> if</c><00:02:30.120><c> we</c><00:02:30.270><c> had</c>

00:02:30.410 --> 00:02:30.420 align:start position:0%
values equal to a value or if we had
 

00:02:30.420 --> 00:02:32.630 align:start position:0%
values equal to a value or if we had
selected<00:02:30.750><c> the</c><00:02:30.960><c> entire</c><00:02:31.110><c> worksheets</c><00:02:31.950><c> we</c><00:02:32.490><c> could</c>

00:02:32.630 --> 00:02:32.640 align:start position:0%
selected the entire worksheets we could
 

00:02:32.640 --> 00:02:34.130 align:start position:0%
selected the entire worksheets we could
apply<00:02:32.850><c> formatting</c><00:02:33.330><c> to</c><00:02:33.600><c> cells</c><00:02:33.630><c> with</c><00:02:34.110><c> a</c>

00:02:34.130 --> 00:02:34.140 align:start position:0%
apply formatting to cells with a
 

00:02:34.140 --> 00:02:38.150 align:start position:0%
apply formatting to cells with a
specific<00:02:34.800><c> date</c><00:02:35.190><c> or</c><00:02:35.400><c> month</c><00:02:35.790><c> listed</c><00:02:36.980><c> you</c><00:02:37.980><c> can</c>

00:02:38.150 --> 00:02:38.160 align:start position:0%
specific date or month listed you can
 

00:02:38.160 --> 00:02:39.980 align:start position:0%
specific date or month listed you can
apply<00:02:38.430><c> conditional</c><00:02:39.060><c> formatting</c><00:02:39.120><c> to</c><00:02:39.810><c> cells</c>

00:02:39.980 --> 00:02:39.990 align:start position:0%
apply conditional formatting to cells
 

00:02:39.990 --> 00:02:43.100 align:start position:0%
apply conditional formatting to cells
that<00:02:40.410><c> are</c><00:02:40.650><c> the</c><00:02:40.800><c> top</c><00:02:41.100><c> or</c><00:02:41.400><c> bottom</c><00:02:41.700><c> 10%</c><00:02:42.180><c> in</c><00:02:42.690><c> value</c>

00:02:43.100 --> 00:02:43.110 align:start position:0%
that are the top or bottom 10% in value
 

00:02:43.110 --> 00:02:45.790 align:start position:0%
that are the top or bottom 10% in value
or<00:02:43.350><c> above</c><00:02:44.220><c> and</c><00:02:44.430><c> below</c><00:02:44.730><c> average</c>

00:02:45.790 --> 00:02:45.800 align:start position:0%
or above and below average
 

00:02:45.800 --> 00:02:51.860 align:start position:0%
or above and below average
let's<00:02:46.800><c> select</c><00:02:47.390><c> above-average</c><00:02:50.600><c> select</c><00:02:51.600><c> the</c>

00:02:51.860 --> 00:02:51.870 align:start position:0%
let's select above-average select the
 

00:02:51.870 --> 00:02:57.260 align:start position:0%
let's select above-average select the
color<00:02:52.200><c> of</c><00:02:52.470><c> formatting</c><00:02:53.070><c> we</c><00:02:53.190><c> want</c><00:02:55.400><c> click</c><00:02:56.400><c> OK</c>

00:02:57.260 --> 00:02:57.270 align:start position:0%
color of formatting we want click OK
 

00:02:57.270 --> 00:03:00.560 align:start position:0%
color of formatting we want click OK
and<00:02:58.040><c> now</c><00:02:59.040><c> those</c><00:02:59.400><c> values</c><00:02:59.940><c> that</c><00:02:59.970><c> are</c><00:03:00.180><c> above</c>

00:03:00.560 --> 00:03:00.570 align:start position:0%
and now those values that are above
 

00:03:00.570 --> 00:03:02.600 align:start position:0%
and now those values that are above
average<00:03:00.810><c> are</c><00:03:01.290><c> highlighted</c><00:03:01.860><c> so</c><00:03:02.040><c> we</c><00:03:02.190><c> can</c><00:03:02.340><c> easily</c>

00:03:02.600 --> 00:03:02.610 align:start position:0%
average are highlighted so we can easily
 

00:03:02.610 --> 00:03:05.660 align:start position:0%
average are highlighted so we can easily
see<00:03:03.170><c> now</c><00:03:04.170><c> let's</c><00:03:04.470><c> clear</c><00:03:04.739><c> the</c><00:03:04.920><c> formatting</c><00:03:05.520><c> on</c>

00:03:05.660 --> 00:03:05.670 align:start position:0%
see now let's clear the formatting on
 

00:03:05.670 --> 00:03:10.160 align:start position:0%
see now let's clear the formatting on
these<00:03:05.880><c> selected</c><00:03:06.540><c> cells</c><00:03:08.450><c> let</c><00:03:09.450><c> me</c><00:03:09.600><c> show</c><00:03:09.780><c> you</c><00:03:09.840><c> one</c>

00:03:10.160 --> 00:03:10.170 align:start position:0%
these selected cells let me show you one
 

00:03:10.170 --> 00:03:11.600 align:start position:0%
these selected cells let me show you one
other<00:03:10.290><c> option</c><00:03:10.590><c> that's</c><00:03:10.950><c> really</c><00:03:11.310><c> one</c><00:03:11.430><c> of</c><00:03:11.459><c> my</c>

00:03:11.600 --> 00:03:11.610 align:start position:0%
other option that's really one of my
 

00:03:11.610 --> 00:03:14.120 align:start position:0%
other option that's really one of my
favorites<00:03:12.180><c> we'll</c><00:03:12.989><c> select</c><00:03:13.230><c> our</c><00:03:13.590><c> order</c><00:03:14.010><c> our</c>

00:03:14.120 --> 00:03:14.130 align:start position:0%
favorites we'll select our order our
 

00:03:14.130 --> 00:03:16.280 align:start position:0%
favorites we'll select our order our
mouse<00:03:14.280><c> again</c><00:03:14.520><c> and</c><00:03:15.420><c> take</c><00:03:15.630><c> a</c><00:03:15.660><c> look</c><00:03:16.110><c> at</c><00:03:16.260><c> a</c>

00:03:16.280 --> 00:03:16.290 align:start position:0%
mouse again and take a look at a
 

00:03:16.290 --> 00:03:18.140 align:start position:0%
mouse again and take a look at a
conditional<00:03:16.890><c> formatting</c><00:03:17.310><c> option</c><00:03:17.730><c> called</c>

00:03:18.140 --> 00:03:18.150 align:start position:0%
conditional formatting option called
 

00:03:18.150 --> 00:03:24.350 align:start position:0%
conditional formatting option called
data<00:03:18.450><c> bars</c><00:03:20.959><c> we'll</c><00:03:21.959><c> select</c><00:03:22.170><c> a</c><00:03:22.470><c> color</c><00:03:22.769><c> and</c><00:03:23.360><c> now</c>

00:03:24.350 --> 00:03:24.360 align:start position:0%
data bars we'll select a color and now
 

00:03:24.360 --> 00:03:26.180 align:start position:0%
data bars we'll select a color and now
these<00:03:24.630><c> values</c><00:03:25.110><c> are</c><00:03:25.260><c> formatted</c><00:03:25.799><c> with</c><00:03:25.920><c> the</c><00:03:26.010><c> data</c>

00:03:26.180 --> 00:03:26.190 align:start position:0%
these values are formatted with the data
 

00:03:26.190 --> 00:03:29.810 align:start position:0%
these values are formatted with the data
bars<00:03:27.110><c> this</c><00:03:28.110><c> allows</c><00:03:28.500><c> us</c><00:03:28.530><c> to</c><00:03:28.709><c> easily</c><00:03:28.830><c> see</c><00:03:29.519><c> which</c>

00:03:29.810 --> 00:03:29.820 align:start position:0%
bars this allows us to easily see which
 

00:03:29.820 --> 00:03:34.729 align:start position:0%
bars this allows us to easily see which
values<00:03:30.420><c> are</c><00:03:30.450><c> greatest</c><00:03:32.989><c> cells</c><00:03:33.989><c> with</c><00:03:34.290><c> smaller</c>

00:03:34.729 --> 00:03:34.739 align:start position:0%
values are greatest cells with smaller
 

00:03:34.739 --> 00:03:37.430 align:start position:0%
values are greatest cells with smaller
values<00:03:35.400><c> appear</c><00:03:36.000><c> with</c><00:03:36.209><c> less</c><00:03:36.600><c> of</c><00:03:36.870><c> the</c><00:03:36.959><c> data</c><00:03:37.170><c> bar</c>

00:03:37.430 --> 00:03:37.440 align:start position:0%
values appear with less of the data bar
 

00:03:37.440 --> 00:03:40.460 align:start position:0%
values appear with less of the data bar
while<00:03:38.190><c> cells</c><00:03:38.640><c> with</c><00:03:38.940><c> greater</c><00:03:39.360><c> values</c><00:03:39.959><c> appear</c>

00:03:40.460 --> 00:03:40.470 align:start position:0%
while cells with greater values appear
 

00:03:40.470 --> 00:03:43.400 align:start position:0%
while cells with greater values appear
with<00:03:40.650><c> more</c><00:03:41.040><c> of</c><00:03:41.280><c> the</c><00:03:41.370><c> data</c><00:03:41.519><c> bar</c><00:03:42.230><c> the</c><00:03:43.230><c> real</c>

00:03:43.400 --> 00:03:43.410 align:start position:0%
with more of the data bar the real
 

00:03:43.410 --> 00:03:45.560 align:start position:0%
with more of the data bar the real
powerful<00:03:43.950><c> parts</c><00:03:44.549><c> of</c><00:03:44.700><c> conditional</c><00:03:45.150><c> formatting</c>

00:03:45.560 --> 00:03:45.570 align:start position:0%
powerful parts of conditional formatting
 

00:03:45.570 --> 00:03:47.780 align:start position:0%
powerful parts of conditional formatting
is<00:03:45.810><c> the</c><00:03:45.900><c> ability</c><00:03:46.170><c> to</c><00:03:46.440><c> apply</c><00:03:46.680><c> multiple</c><00:03:47.250><c> rules</c>

00:03:47.780 --> 00:03:47.790 align:start position:0%
is the ability to apply multiple rules
 

00:03:47.790 --> 00:03:51.140 align:start position:0%
is the ability to apply multiple rules
or<00:03:48.269><c> formatting</c><00:03:49.200><c> to</c><00:03:49.350><c> cells</c><00:03:49.489><c> right</c><00:03:50.489><c> now</c><00:03:50.790><c> we</c><00:03:50.850><c> have</c>

00:03:51.140 --> 00:03:51.150 align:start position:0%
or formatting to cells right now we have
 

00:03:51.150 --> 00:03:53.330 align:start position:0%
or formatting to cells right now we have
data<00:03:51.360><c> bars</c><00:03:51.720><c> apply</c><00:03:52.170><c> to</c><00:03:52.230><c> the</c><00:03:52.560><c> cells</c><00:03:52.830><c> that</c><00:03:53.040><c> show</c>

00:03:53.330 --> 00:03:53.340 align:start position:0%
data bars apply to the cells that show
 

00:03:53.340 --> 00:03:57.520 align:start position:0%
data bars apply to the cells that show
us<00:03:53.519><c> which</c><00:03:53.790><c> cells</c><00:03:54.150><c> have</c><00:03:54.480><c> the</c><00:03:54.600><c> largest</c><00:03:54.959><c> values</c>

00:03:57.520 --> 00:03:57.530 align:start position:0%
us which cells have the largest values
 

00:03:57.530 --> 00:04:01.759 align:start position:0%
us which cells have the largest values
now<00:03:58.530><c> what</c><00:03:59.489><c> if</c><00:03:59.670><c> I</c><00:03:59.820><c> also</c><00:04:00.090><c> want</c><00:04:00.630><c> to</c><00:04:00.720><c> mark</c><00:04:01.200><c> the</c><00:04:01.440><c> ones</c>

00:04:01.759 --> 00:04:01.769 align:start position:0%
now what if I also want to mark the ones
 

00:04:01.769 --> 00:04:04.220 align:start position:0%
now what if I also want to mark the ones
that<00:04:02.070><c> are</c><00:04:02.190><c> below</c><00:04:02.580><c> average</c><00:04:02.910><c> or</c><00:04:03.360><c> equal</c><00:04:04.049><c> to</c><00:04:04.200><c> a</c>

00:04:04.220 --> 00:04:04.230 align:start position:0%
that are below average or equal to a
 

00:04:04.230 --> 00:04:08.150 align:start position:0%
that are below average or equal to a
certain<00:04:04.590><c> amount</c><00:04:06.170><c> now</c><00:04:07.170><c> you</c><00:04:07.230><c> can</c><00:04:07.590><c> see</c><00:04:07.830><c> that</c><00:04:08.010><c> we</c>

00:04:08.150 --> 00:04:08.160 align:start position:0%
certain amount now you can see that we
 

00:04:08.160 --> 00:04:10.100 align:start position:0%
certain amount now you can see that we
have<00:04:08.370><c> our</c><00:04:08.549><c> formatting</c><00:04:09.180><c> for</c><00:04:09.450><c> the</c><00:04:09.510><c> data</c><00:04:09.810><c> bars</c>

00:04:10.100 --> 00:04:10.110 align:start position:0%
have our formatting for the data bars
 

00:04:10.110 --> 00:04:14.360 align:start position:0%
have our formatting for the data bars
and<00:04:10.500><c> for</c><00:04:10.890><c> the</c><00:04:10.950><c> below</c><00:04:11.250><c> average</c><00:04:11.280><c> sales</c><00:04:13.370><c> before</c>

00:04:14.360 --> 00:04:14.370 align:start position:0%
and for the below average sales before
 

00:04:14.370 --> 00:04:15.979 align:start position:0%
and for the below average sales before
we<00:04:14.519><c> finish</c><00:04:14.790><c> talking</c><00:04:15.209><c> about</c><00:04:15.450><c> conditional</c>

00:04:15.979 --> 00:04:15.989 align:start position:0%
we finish talking about conditional
 

00:04:15.989 --> 00:04:18.380 align:start position:0%
we finish talking about conditional
formatting<00:04:16.440><c> let</c><00:04:17.100><c> me</c><00:04:17.250><c> show</c><00:04:17.489><c> you</c><00:04:17.549><c> how</c><00:04:17.850><c> you</c><00:04:17.910><c> can</c>

00:04:18.380 --> 00:04:18.390 align:start position:0%
formatting let me show you how you can
 

00:04:18.390 --> 00:04:20.990 align:start position:0%
formatting let me show you how you can
have<00:04:18.600><c> more</c><00:04:18.930><c> control</c><00:04:19.320><c> over</c><00:04:19.799><c> these</c><00:04:20.430><c> formatting</c>

00:04:20.990 --> 00:04:21.000 align:start position:0%
have more control over these formatting
 

00:04:21.000 --> 00:04:23.930 align:start position:0%
have more control over these formatting
rules<00:04:21.269><c> if</c><00:04:21.690><c> you</c><00:04:22.680><c> click</c><00:04:23.039><c> the</c><00:04:23.340><c> conditional</c>

00:04:23.930 --> 00:04:23.940 align:start position:0%
rules if you click the conditional
 

00:04:23.940 --> 00:04:26.420 align:start position:0%
rules if you click the conditional
formatting<00:04:24.110><c> commands</c><00:04:25.110><c> you'll</c><00:04:25.620><c> see</c><00:04:25.890><c> manage</c>

00:04:26.420 --> 00:04:26.430 align:start position:0%
formatting commands you'll see manage
 

00:04:26.430 --> 00:04:27.770 align:start position:0%
formatting commands you'll see manage
rules<00:04:26.760><c> at</c><00:04:27.150><c> the</c><00:04:27.300><c> bottom</c>

00:04:27.770 --> 00:04:27.780 align:start position:0%
rules at the bottom
 

00:04:27.780 --> 00:04:31.520 align:start position:0%
rules at the bottom
the<00:04:27.930><c> menu</c><00:04:28.320><c> select</c><00:04:29.130><c> this</c><00:04:29.760><c> and</c><00:04:30.150><c> the</c><00:04:30.720><c> dialog</c><00:04:31.230><c> box</c>

00:04:31.520 --> 00:04:31.530 align:start position:0%
the menu select this and the dialog box
 

00:04:31.530 --> 00:04:35.030 align:start position:0%
the menu select this and the dialog box
will<00:04:31.740><c> appear</c><00:04:32.270><c> from</c><00:04:33.270><c> here</c><00:04:33.720><c> you</c><00:04:34.320><c> can</c><00:04:34.470><c> change</c><00:04:34.680><c> how</c>

00:04:35.030 --> 00:04:35.040 align:start position:0%
will appear from here you can change how
 

00:04:35.040 --> 00:04:36.770 align:start position:0%
will appear from here you can change how
your<00:04:35.280><c> selective</c><00:04:35.760><c> formatting</c><00:04:36.210><c> rules</c><00:04:36.480><c> are</c>

00:04:36.770 --> 00:04:36.780 align:start position:0%
your selective formatting rules are
 

00:04:36.780 --> 00:04:41.780 align:start position:0%
your selective formatting rules are
applied<00:04:37.169><c> you</c><00:04:37.590><c> can</c><00:04:38.490><c> select</c><00:04:38.639><c> a</c><00:04:39.000><c> rule</c><00:04:39.270><c> and</c><00:04:40.790><c> move</c>

00:04:41.780 --> 00:04:41.790 align:start position:0%
applied you can select a rule and move
 

00:04:41.790 --> 00:04:46.010 align:start position:0%
applied you can select a rule and move
it<00:04:41.910><c> up</c><00:04:42.090><c> or</c><00:04:42.300><c> down</c><00:04:44.180><c> which</c><00:04:45.180><c> will</c><00:04:45.389><c> make</c><00:04:45.690><c> it</c><00:04:45.840><c> so</c>

00:04:46.010 --> 00:04:46.020 align:start position:0%
it up or down which will make it so
 

00:04:46.020 --> 00:04:48.530 align:start position:0%
it up or down which will make it so
Excel<00:04:46.440><c> performs</c><00:04:46.980><c> this</c><00:04:47.190><c> formatting</c><00:04:47.760><c> rule</c><00:04:48.090><c> in</c><00:04:48.419><c> a</c>

00:04:48.530 --> 00:04:48.540 align:start position:0%
Excel performs this formatting rule in a
 

00:04:48.540 --> 00:04:53.840 align:start position:0%
Excel performs this formatting rule in a
different<00:04:48.930><c> order</c><00:04:49.880><c> you</c><00:04:50.880><c> can</c><00:04:51.090><c> edit</c><00:04:51.419><c> a</c><00:04:51.720><c> rule</c><00:04:52.850><c> or</c>

00:04:53.840 --> 00:04:53.850 align:start position:0%
different order you can edit a rule or
 

00:04:53.850 --> 00:04:58.730 align:start position:0%
different order you can edit a rule or
even<00:04:53.930><c> delete</c><00:04:54.930><c> a</c><00:04:55.350><c> rule</c><00:04:56.690><c> we'll</c><00:04:57.690><c> just</c><00:04:57.930><c> click</c><00:04:58.080><c> OK</c>

00:04:58.730 --> 00:04:58.740 align:start position:0%
even delete a rule we'll just click OK
 

00:04:58.740 --> 00:05:01.610 align:start position:0%
even delete a rule we'll just click OK
and<00:04:59.510><c> now</c><00:05:00.510><c> you</c><00:05:00.570><c> can</c><00:05:00.870><c> see</c><00:05:01.050><c> that</c><00:05:01.169><c> the</c><00:05:01.290><c> formatting</c>

00:05:01.610 --> 00:05:01.620 align:start position:0%
and now you can see that the formatting
 

00:05:01.620 --> 00:05:04.100 align:start position:0%
and now you can see that the formatting
to<00:05:02.130><c> the</c><00:05:02.160><c> below-average</c><00:05:02.700><c> cells</c><00:05:03.510><c> has</c><00:05:03.930><c> been</c>

00:05:04.100 --> 00:05:04.110 align:start position:0%
to the below-average cells has been
 

00:05:04.110 --> 00:05:06.159 align:start position:0%
to the below-average cells has been
deleted

00:05:06.159 --> 00:05:06.169 align:start position:0%
deleted
 

00:05:06.169 --> 00:05:09.520 align:start position:0%
deleted
while<00:05:07.169><c> this</c><00:05:07.410><c> spreadsheets</c><00:05:08.040><c> only</c><00:05:08.340><c> has</c><00:05:08.550><c> 40</c><00:05:09.030><c> rows</c>

00:05:09.520 --> 00:05:09.530 align:start position:0%
while this spreadsheets only has 40 rows
 

00:05:09.530 --> 00:05:11.330 align:start position:0%
while this spreadsheets only has 40 rows
imagine<00:05:10.530><c> you</c><00:05:10.650><c> are</c><00:05:10.800><c> working</c><00:05:11.220><c> with</c><00:05:11.310><c> a</c>

00:05:11.330 --> 00:05:11.340 align:start position:0%
imagine you are working with a
 

00:05:11.340 --> 00:05:14.300 align:start position:0%
imagine you are working with a
spreadsheet<00:05:11.790><c> with</c><00:05:12.180><c> hundreds</c><00:05:12.660><c> of</c><00:05:12.780><c> rows</c><00:05:13.310><c> data</c>

00:05:14.300 --> 00:05:14.310 align:start position:0%
spreadsheet with hundreds of rows data
 

00:05:14.310 --> 00:05:16.100 align:start position:0%
spreadsheet with hundreds of rows data
bars<00:05:14.669><c> and</c><00:05:15.030><c> the</c><00:05:15.390><c> other</c><00:05:15.570><c> conditional</c>

00:05:16.100 --> 00:05:16.110 align:start position:0%
bars and the other conditional
 

00:05:16.110 --> 00:05:18.170 align:start position:0%
bars and the other conditional
formatting<00:05:16.500><c> options</c><00:05:17.010><c> make</c><00:05:17.250><c> it</c><00:05:17.400><c> very</c><00:05:17.640><c> easy</c><00:05:18.000><c> to</c>

00:05:18.170 --> 00:05:18.180 align:start position:0%
formatting options make it very easy to
 

00:05:18.180 --> 00:05:21.800 align:start position:0%
formatting options make it very easy to
see<00:05:18.300><c> data</c><00:05:18.750><c> in</c><00:05:18.990><c> meaningful</c><00:05:19.229><c> ways</c>