WEBVTT
Kind: captions
Language: en

00:00:10.260 --> 00:00:12.660 align:start position:0%
 
we've<00:00:11.260><c> already</c><00:00:11.470><c> looked</c><00:00:11.800><c> at</c><00:00:12.040><c> ways</c><00:00:12.220><c> that</c><00:00:12.550><c> you</c>

00:00:12.660 --> 00:00:12.670 align:start position:0%
we've already looked at ways that you
 

00:00:12.670 --> 00:00:14.940 align:start position:0%
we've already looked at ways that you
can<00:00:12.850><c> visualize</c><00:00:13.330><c> your</c><00:00:13.540><c> data</c><00:00:13.600><c> using</c><00:00:14.290><c> charts</c><00:00:14.709><c> and</c>

00:00:14.940 --> 00:00:14.950 align:start position:0%
can visualize your data using charts and
 

00:00:14.950 --> 00:00:17.880 align:start position:0%
can visualize your data using charts and
sparklines<00:00:15.930><c> conditional</c><00:00:16.930><c> formatting</c><00:00:17.350><c> offers</c>

00:00:17.880 --> 00:00:17.890 align:start position:0%
sparklines conditional formatting offers
 

00:00:17.890 --> 00:00:19.680 align:start position:0%
sparklines conditional formatting offers
a<00:00:17.920><c> different</c><00:00:18.520><c> way</c><00:00:18.670><c> of</c><00:00:18.910><c> visualizing</c><00:00:19.270><c> data</c>

00:00:19.680 --> 00:00:19.690 align:start position:0%
a different way of visualizing data
 

00:00:19.690 --> 00:00:22.020 align:start position:0%
a different way of visualizing data
because<00:00:20.320><c> it</c><00:00:20.440><c> allows</c><00:00:20.650><c> you</c><00:00:20.890><c> to</c><00:00:20.920><c> apply</c><00:00:21.250><c> rules</c><00:00:21.730><c> to</c>

00:00:22.020 --> 00:00:22.030 align:start position:0%
because it allows you to apply rules to
 

00:00:22.030 --> 00:00:24.120 align:start position:0%
because it allows you to apply rules to
the<00:00:22.150><c> cells</c><00:00:22.390><c> that</c><00:00:22.840><c> will</c><00:00:22.960><c> add</c><00:00:23.110><c> formatting</c><00:00:23.770><c> such</c>

00:00:24.120 --> 00:00:24.130 align:start position:0%
the cells that will add formatting such
 

00:00:24.130 --> 00:00:26.850 align:start position:0%
the cells that will add formatting such
as<00:00:24.310><c> color</c><00:00:24.580><c> coding</c><00:00:25.060><c> based</c><00:00:25.750><c> on</c><00:00:25.960><c> the</c><00:00:26.080><c> cells</c><00:00:26.320><c> value</c>

00:00:26.850 --> 00:00:26.860 align:start position:0%
as color coding based on the cells value
 

00:00:26.860 --> 00:00:30.300 align:start position:0%
as color coding based on the cells value
in<00:00:27.390><c> this</c><00:00:28.390><c> example</c><00:00:28.810><c> we</c><00:00:29.080><c> have</c><00:00:29.110><c> sales</c><00:00:29.620><c> statistics</c>

00:00:30.300 --> 00:00:30.310 align:start position:0%
in this example we have sales statistics
 

00:00:30.310 --> 00:00:31.950 align:start position:0%
in this example we have sales statistics
for<00:00:30.640><c> a</c><00:00:30.700><c> number</c><00:00:31.120><c> of</c><00:00:31.150><c> different</c><00:00:31.360><c> salespeople</c>

00:00:31.950 --> 00:00:31.960 align:start position:0%
for a number of different salespeople
 

00:00:31.960 --> 00:00:34.950 align:start position:0%
for a number of different salespeople
and<00:00:32.290><c> let's</c><00:00:33.280><c> say</c><00:00:33.489><c> that</c><00:00:33.520><c> the</c><00:00:33.850><c> sales</c><00:00:34.149><c> goal</c><00:00:34.600><c> for</c>

00:00:34.950 --> 00:00:34.960 align:start position:0%
and let's say that the sales goal for
 

00:00:34.960 --> 00:00:39.150 align:start position:0%
and let's say that the sales goal for
each<00:00:34.989><c> person</c><00:00:35.530><c> is</c><00:00:36.360><c> $5,000</c><00:00:37.360><c> per</c><00:00:37.600><c> month</c><00:00:38.010><c> we</c><00:00:39.010><c> can</c>

00:00:39.150 --> 00:00:39.160 align:start position:0%
each person is $5,000 per month we can
 

00:00:39.160 --> 00:00:41.250 align:start position:0%
each person is $5,000 per month we can
use<00:00:39.339><c> conditional</c><00:00:39.940><c> formatting</c><00:00:39.969><c> to</c><00:00:40.780><c> see</c><00:00:41.019><c> who</c>

00:00:41.250 --> 00:00:41.260 align:start position:0%
use conditional formatting to see who
 

00:00:41.260 --> 00:00:45.299 align:start position:0%
use conditional formatting to see who
met<00:00:41.559><c> or</c><00:00:41.769><c> exceeded</c><00:00:41.800><c> this</c><00:00:42.550><c> goal</c><00:00:43.620><c> first</c><00:00:44.620><c> select</c>

00:00:45.299 --> 00:00:45.309 align:start position:0%
met or exceeded this goal first select
 

00:00:45.309 --> 00:00:49.600 align:start position:0%
met or exceeded this goal first select
the<00:00:45.489><c> data</c>

00:00:49.600 --> 00:00:49.610 align:start position:0%
 
 

00:00:49.610 --> 00:00:51.880 align:start position:0%
 
and<00:00:49.700><c> then</c><00:00:50.660><c> go</c><00:00:50.870><c> to</c><00:00:50.900><c> the</c><00:00:51.380><c> conditional</c>

00:00:51.880 --> 00:00:51.890 align:start position:0%
and then go to the conditional
 

00:00:51.890 --> 00:00:54.840 align:start position:0%
and then go to the conditional
formatting<00:00:52.280><c> command</c><00:00:52.670><c> on</c><00:00:52.880><c> the</c><00:00:53.000><c> Home</c><00:00:53.150><c> tab</c>

00:00:54.840 --> 00:00:54.850 align:start position:0%
formatting command on the Home tab
 

00:00:54.850 --> 00:00:57.299 align:start position:0%
formatting command on the Home tab
and<00:00:54.940><c> then</c><00:00:55.539><c> click</c><00:00:55.809><c> highlight</c><00:00:56.289><c> cells</c><00:00:56.590><c> rules</c><00:00:56.739><c> and</c>

00:00:57.299 --> 00:00:57.309 align:start position:0%
and then click highlight cells rules and
 

00:00:57.309 --> 00:01:01.299 align:start position:0%
and then click highlight cells rules and
select<00:00:58.180><c> greater</c><00:00:58.600><c> than</c>

00:01:01.299 --> 00:01:01.309 align:start position:0%
 
 

00:01:01.309 --> 00:01:03.369 align:start position:0%
 
we<00:01:01.910><c> want</c><00:01:02.090><c> to</c><00:01:02.149><c> format</c><00:01:02.449><c> cells</c><00:01:02.690><c> that</c><00:01:02.989><c> are</c><00:01:03.110><c> greater</c>

00:01:03.369 --> 00:01:03.379 align:start position:0%
we want to format cells that are greater
 

00:01:03.379 --> 00:01:09.810 align:start position:0%
we want to format cells that are greater
than<00:01:03.549><c> 5000</c><00:01:04.549><c> so</c><00:01:05.089><c> we'll</c><00:01:05.360><c> type</c><00:01:05.540><c> that</c><00:01:05.840><c> here</c>

00:01:09.810 --> 00:01:09.820 align:start position:0%
 
 

00:01:09.820 --> 00:01:12.410 align:start position:0%
 
and<00:01:09.909><c> then</c><00:01:10.540><c> just</c><00:01:10.780><c> choose</c><00:01:11.080><c> a</c><00:01:11.140><c> formatting</c><00:01:11.860><c> option</c>

00:01:12.410 --> 00:01:12.420 align:start position:0%
and then just choose a formatting option
 

00:01:12.420 --> 00:01:15.480 align:start position:0%
and then just choose a formatting option
I'll<00:01:13.420><c> choose</c><00:01:13.780><c> green</c><00:01:14.170><c> fill</c><00:01:14.500><c> with</c><00:01:14.890><c> dark</c><00:01:14.920><c> green</c>

00:01:15.480 --> 00:01:15.490 align:start position:0%
I'll choose green fill with dark green
 

00:01:15.490 --> 00:01:20.740 align:start position:0%
I'll choose green fill with dark green
text

00:01:20.740 --> 00:01:20.750 align:start position:0%
 
 

00:01:20.750 --> 00:01:24.740 align:start position:0%
 
so<00:01:21.410><c> it</c><00:01:21.560><c> really</c><00:01:21.890><c> makes</c><00:01:22.130><c> those</c><00:01:22.400><c> cells</c><00:01:22.700><c> stand</c><00:01:23.150><c> out</c>

00:01:24.740 --> 00:01:24.750 align:start position:0%
so it really makes those cells stand out
 

00:01:24.750 --> 00:01:26.750 align:start position:0%
so it really makes those cells stand out
you<00:01:25.320><c> can</c><00:01:25.470><c> see</c><00:01:25.650><c> that</c><00:01:25.830><c> not</c><00:01:26.070><c> many</c><00:01:26.310><c> salespeople</c>

00:01:26.750 --> 00:01:26.760 align:start position:0%
you can see that not many salespeople
 

00:01:26.760 --> 00:01:29.270 align:start position:0%
you can see that not many salespeople
met<00:01:27.180><c> the</c><00:01:27.300><c> goal</c><00:01:27.480><c> in</c><00:01:27.720><c> June</c><00:01:28.020><c> or</c><00:01:28.140><c> August</c><00:01:28.280><c> but</c>

00:01:29.270 --> 00:01:29.280 align:start position:0%
met the goal in June or August but
 

00:01:29.280 --> 00:01:35.260 align:start position:0%
met the goal in June or August but
September<00:01:29.820><c> and</c><00:01:29.940><c> October</c><00:01:30.030><c> were</c><00:01:30.570><c> much</c><00:01:30.780><c> better</c>

00:01:35.260 --> 00:01:35.270 align:start position:0%
 
 

00:01:35.270 --> 00:01:36.880 align:start position:0%
 
now<00:01:35.869><c> let's</c><00:01:36.110><c> look</c><00:01:36.290><c> at</c><00:01:36.409><c> some</c><00:01:36.650><c> of</c><00:01:36.770><c> the</c>

00:01:36.880 --> 00:01:36.890 align:start position:0%
now let's look at some of the
 

00:01:36.890 --> 00:01:39.910 align:start position:0%
now let's look at some of the
conditional<00:01:37.399><c> formatting</c><00:01:37.790><c> presets</c><00:01:38.540><c> I'm</c><00:01:38.920><c> going</c>

00:01:39.910 --> 00:01:39.920 align:start position:0%
conditional formatting presets I'm going
 

00:01:39.920 --> 00:01:44.399 align:start position:0%
conditional formatting presets I'm going
to<00:01:40.040><c> reselect</c><00:01:40.579><c> these</c><00:01:40.880><c> cells</c>

00:01:44.399 --> 00:01:44.409 align:start position:0%
 
 

00:01:44.409 --> 00:01:48.630 align:start position:0%
 
go<00:01:44.619><c> back</c><00:01:44.829><c> to</c><00:01:45.100><c> conditional</c><00:01:45.729><c> formatting</c>

00:01:48.630 --> 00:01:48.640 align:start position:0%
 
 

00:01:48.640 --> 00:01:50.850 align:start position:0%
 
there<00:01:49.420><c> are</c><00:01:49.660><c> three</c><00:01:49.990><c> different</c><00:01:50.200><c> types</c><00:01:50.620><c> of</c>

00:01:50.850 --> 00:01:50.860 align:start position:0%
there are three different types of
 

00:01:50.860 --> 00:01:53.910 align:start position:0%
there are three different types of
presets<00:01:51.370><c> data</c><00:01:52.330><c> bars</c><00:01:52.630><c> which</c><00:01:53.230><c> are</c><00:01:53.470><c> kind</c><00:01:53.710><c> of</c><00:01:53.740><c> like</c>

00:01:53.910 --> 00:01:53.920 align:start position:0%
presets data bars which are kind of like
 

00:01:53.920 --> 00:01:55.980 align:start position:0%
presets data bars which are kind of like
a<00:01:53.950><c> bar</c><00:01:54.250><c> graph</c>

00:01:55.980 --> 00:01:55.990 align:start position:0%
a bar graph
 

00:01:55.990 --> 00:01:59.190 align:start position:0%
a bar graph
color<00:01:56.799><c> scales</c><00:01:57.250><c> which</c><00:01:58.060><c> change</c><00:01:58.540><c> the</c><00:01:58.630><c> background</c>

00:01:59.190 --> 00:01:59.200 align:start position:0%
color scales which change the background
 

00:01:59.200 --> 00:02:02.040 align:start position:0%
color scales which change the background
color<00:01:59.500><c> based</c><00:01:59.920><c> on</c><00:02:00.159><c> the</c><00:02:00.220><c> value</c>

00:02:02.040 --> 00:02:02.050 align:start position:0%
color based on the value
 

00:02:02.050 --> 00:02:05.610 align:start position:0%
color based on the value
and<00:02:02.580><c> icon</c><00:02:03.580><c> sets</c><00:02:03.970><c> which</c><00:02:04.630><c> put</c><00:02:04.900><c> different</c><00:02:05.230><c> icons</c>

00:02:05.610 --> 00:02:05.620 align:start position:0%
and icon sets which put different icons
 

00:02:05.620 --> 00:02:07.969 align:start position:0%
and icon sets which put different icons
in<00:02:05.860><c> the</c><00:02:05.950><c> cells</c><00:02:06.160><c> depending</c><00:02:06.850><c> on</c><00:02:07.000><c> their</c><00:02:07.150><c> value</c><00:02:07.510><c> I</c>

00:02:07.969 --> 00:02:07.979 align:start position:0%
in the cells depending on their value I
 

00:02:07.979 --> 00:02:10.469 align:start position:0%
in the cells depending on their value I
think<00:02:08.979><c> this</c><00:02:09.160><c> one</c><00:02:09.369><c> is</c><00:02:09.400><c> especially</c><00:02:09.760><c> easy</c><00:02:10.300><c> to</c>

00:02:10.469 --> 00:02:10.479 align:start position:0%
think this one is especially easy to
 

00:02:10.479 --> 00:02:14.230 align:start position:0%
think this one is especially easy to
read

00:02:14.230 --> 00:02:14.240 align:start position:0%
 
 

00:02:14.240 --> 00:02:16.780 align:start position:0%
 
the<00:02:14.930><c> icons</c><00:02:15.320><c> help</c><00:02:15.500><c> us</c><00:02:15.680><c> to</c><00:02:15.830><c> see</c><00:02:16.040><c> which</c><00:02:16.310><c> items</c><00:02:16.640><c> are</c>

00:02:16.780 --> 00:02:16.790 align:start position:0%
the icons help us to see which items are
 

00:02:16.790 --> 00:02:19.240 align:start position:0%
the icons help us to see which items are
the<00:02:16.970><c> highest</c><00:02:17.360><c> and</c><00:02:17.570><c> the</c><00:02:17.720><c> lowest</c><00:02:17.750><c> and</c><00:02:18.260><c> which</c>

00:02:19.240 --> 00:02:19.250 align:start position:0%
the highest and the lowest and which
 

00:02:19.250 --> 00:02:22.840 align:start position:0%
the highest and the lowest and which
ones<00:02:19.520><c> are</c><00:02:19.790><c> about</c><00:02:20.210><c> average</c><00:02:21.430><c> you</c><00:02:22.430><c> might</c><00:02:22.610><c> also</c>

00:02:22.840 --> 00:02:22.850 align:start position:0%
ones are about average you might also
 

00:02:22.850 --> 00:02:25.150 align:start position:0%
ones are about average you might also
notice<00:02:23.240><c> that</c><00:02:23.420><c> the</c><00:02:23.870><c> first</c><00:02:24.110><c> rule</c><00:02:24.380><c> we</c><00:02:24.530><c> created</c><00:02:25.040><c> is</c>

00:02:25.150 --> 00:02:25.160 align:start position:0%
notice that the first rule we created is
 

00:02:25.160 --> 00:02:28.030 align:start position:0%
notice that the first rule we created is
still<00:02:25.760><c> visible</c><00:02:26.030><c> and</c><00:02:26.420><c> that's</c><00:02:27.140><c> because</c><00:02:27.530><c> Excel</c>

00:02:28.030 --> 00:02:28.040 align:start position:0%
still visible and that's because Excel
 

00:02:28.040 --> 00:02:29.800 align:start position:0%
still visible and that's because Excel
lets<00:02:28.310><c> you</c><00:02:28.490><c> have</c><00:02:28.670><c> multiple</c><00:02:29.270><c> conditional</c>

00:02:29.800 --> 00:02:29.810 align:start position:0%
lets you have multiple conditional
 

00:02:29.810 --> 00:02:33.700 align:start position:0%
lets you have multiple conditional
formatting<00:02:30.200><c> rules</c><00:02:30.500><c> at</c><00:02:30.770><c> the</c><00:02:31.220><c> same</c><00:02:31.490><c> time</c><00:02:32.710><c> to</c>

00:02:33.700 --> 00:02:33.710 align:start position:0%
formatting rules at the same time to
 

00:02:33.710 --> 00:02:35.920 align:start position:0%
formatting rules at the same time to
clear<00:02:33.980><c> all</c><00:02:34.190><c> of</c><00:02:34.220><c> the</c><00:02:34.520><c> rules</c><00:02:34.700><c> just</c><00:02:35.360><c> select</c><00:02:35.780><c> the</c>

00:02:35.920 --> 00:02:35.930 align:start position:0%
clear all of the rules just select the
 

00:02:35.930 --> 00:02:39.210 align:start position:0%
clear all of the rules just select the
cells

00:02:39.210 --> 00:02:39.220 align:start position:0%
 
 

00:02:39.220 --> 00:02:41.910 align:start position:0%
 
then<00:02:39.340><c> go</c><00:02:39.490><c> to</c><00:02:39.550><c> conditional</c><00:02:40.090><c> formatting</c><00:02:40.920><c> clear</c>

00:02:41.910 --> 00:02:41.920 align:start position:0%
then go to conditional formatting clear
 

00:02:41.920 --> 00:02:44.550 align:start position:0%
then go to conditional formatting clear
rules<00:02:42.220><c> and</c><00:02:42.810><c> you'll</c><00:02:43.810><c> have</c><00:02:43.960><c> a</c><00:02:43.990><c> few</c><00:02:44.290><c> different</c>

00:02:44.550 --> 00:02:44.560 align:start position:0%
rules and you'll have a few different
 

00:02:44.560 --> 00:02:47.760 align:start position:0%
rules and you'll have a few different
options<00:02:45.120><c> but</c><00:02:46.120><c> I'd</c><00:02:46.330><c> like</c><00:02:46.510><c> to</c><00:02:46.720><c> just</c><00:02:47.080><c> remove</c><00:02:47.470><c> the</c>

00:02:47.760 --> 00:02:47.770 align:start position:0%
options but I'd like to just remove the
 

00:02:47.770 --> 00:02:50.460 align:start position:0%
options but I'd like to just remove the
greater<00:02:48.040><c> than</c><00:02:48.280><c> 5000</c><00:02:49.120><c> rule</c><00:02:49.270><c> while</c><00:02:49.870><c> keeping</c><00:02:50.350><c> the</c>

00:02:50.460 --> 00:02:50.470 align:start position:0%
greater than 5000 rule while keeping the
 

00:02:50.470 --> 00:02:57.370 align:start position:0%
greater than 5000 rule while keeping the
icons<00:02:51.120><c> to</c><00:02:52.120><c> do</c><00:02:52.270><c> this</c><00:02:52.480><c> go</c><00:02:53.170><c> to</c><00:02:53.230><c> manage</c><00:02:54.160><c> rules</c>

00:02:57.370 --> 00:02:57.380 align:start position:0%
 
 

00:02:57.380 --> 00:02:59.320 align:start position:0%
 
you'll<00:02:57.920><c> see</c><00:02:58.130><c> a</c><00:02:58.160><c> list</c><00:02:58.430><c> of</c><00:02:58.640><c> all</c><00:02:58.850><c> of</c><00:02:58.880><c> the</c><00:02:59.120><c> rules</c>

00:02:59.320 --> 00:02:59.330 align:start position:0%
you'll see a list of all of the rules
 

00:02:59.330 --> 00:03:01.810 align:start position:0%
you'll see a list of all of the rules
that<00:02:59.480><c> you've</c><00:02:59.780><c> applied</c><00:03:00.080><c> and</c><00:03:00.500><c> you</c><00:03:01.460><c> can</c><00:03:01.610><c> just</c>

00:03:01.810 --> 00:03:01.820 align:start position:0%
that you've applied and you can just
 

00:03:01.820 --> 00:03:09.800 align:start position:0%
that you've applied and you can just
select<00:03:02.000><c> one</c><00:03:02.390><c> of</c><00:03:02.420><c> them</c><00:03:02.630><c> and</c><00:03:03.400><c> click</c><00:03:04.400><c> delete</c><00:03:04.730><c> rule</c>

00:03:09.800 --> 00:03:09.810 align:start position:0%
 
 

00:03:09.810 --> 00:03:12.230 align:start position:0%
 
so<00:03:10.500><c> practice</c><00:03:11.010><c> using</c><00:03:11.400><c> the</c><00:03:11.550><c> different</c><00:03:11.850><c> types</c><00:03:12.060><c> of</c>

00:03:12.230 --> 00:03:12.240 align:start position:0%
so practice using the different types of
 

00:03:12.240 --> 00:03:14.809 align:start position:0%
so practice using the different types of
conditional<00:03:12.750><c> formatting</c><00:03:13.170><c> and</c><00:03:13.380><c> try</c><00:03:14.310><c> combining</c>

00:03:14.809 --> 00:03:14.819 align:start position:0%
conditional formatting and try combining
 

00:03:14.819 --> 00:03:16.460 align:start position:0%
conditional formatting and try combining
different<00:03:15.000><c> ones</c><00:03:15.360><c> to</c><00:03:15.540><c> see</c><00:03:15.810><c> what</c><00:03:15.990><c> they</c><00:03:16.110><c> tell</c><00:03:16.290><c> you</c>

00:03:16.460 --> 00:03:16.470 align:start position:0%
different ones to see what they tell you
 

00:03:16.470 --> 00:03:20.770 align:start position:0%
different ones to see what they tell you
about<00:03:16.740><c> your</c><00:03:17.100><c> data</c><00:03:18.530><c> like</c><00:03:19.530><c> what</c><00:03:19.740><c> you</c><00:03:19.890><c> just</c><00:03:20.069><c> saw</c>

00:03:20.770 --> 00:03:20.780 align:start position:0%
about your data like what you just saw
 

00:03:20.780 --> 00:03:24.110 align:start position:0%
about your data like what you just saw
rate<00:03:21.780><c> it</c><00:03:21.959><c> add</c><00:03:22.470><c> a</c><00:03:22.530><c> comment</c><00:03:22.860><c> subscribe</c><00:03:23.610><c> to</c><00:03:23.880><c> our</c>

00:03:24.110 --> 00:03:24.120 align:start position:0%
rate it add a comment subscribe to our
 

00:03:24.120 --> 00:03:28.190 align:start position:0%
rate it add a comment subscribe to our
channel<00:03:24.620><c> the</c><00:03:25.620><c> freedom</c><00:03:26.040><c> to</c><00:03:26.190><c> learn</c><00:03:26.989><c> what</c><00:03:27.989><c> you</c>

00:03:28.190 --> 00:03:28.200 align:start position:0%
channel the freedom to learn what you
 

00:03:28.200 --> 00:03:36.259 align:start position:0%
channel the freedom to learn what you
want<00:03:28.700><c> when</c><00:03:29.700><c> you</c><00:03:29.880><c> want</c><00:03:31.580><c> absolutely</c><00:03:32.580><c> free</c>

00:03:36.259 --> 00:03:36.269 align:start position:0%
 
 

00:03:36.269 --> 00:03:39.870 align:start position:0%
 
GCF<00:03:37.269><c> learn</c><00:03:37.840><c> free.org</c>