WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.550><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.589 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.589 --> 00:00:10.599 align:start position:0%
 
 

00:00:10.599 --> 00:00:12.509 align:start position:0%
 
you<00:00:11.530><c> may</c><00:00:11.679><c> already</c><00:00:11.860><c> have</c><00:00:12.070><c> some</c><00:00:12.400><c> experience</c>

00:00:12.509 --> 00:00:12.519 align:start position:0%
you may already have some experience
 

00:00:12.519 --> 00:00:15.240 align:start position:0%
you may already have some experience
using<00:00:13.240><c> charts</c><00:00:13.719><c> and</c><00:00:13.929><c> sparklines</c><00:00:14.440><c> to</c><00:00:14.740><c> visualize</c>

00:00:15.240 --> 00:00:15.250 align:start position:0%
using charts and sparklines to visualize
 

00:00:15.250 --> 00:00:17.970 align:start position:0%
using charts and sparklines to visualize
data<00:00:15.459><c> in</c><00:00:15.760><c> Excel</c><00:00:16.199><c> conditional</c><00:00:17.199><c> formatting</c>

00:00:17.970 --> 00:00:17.980 align:start position:0%
data in Excel conditional formatting
 

00:00:17.980 --> 00:00:19.890 align:start position:0%
data in Excel conditional formatting
offers<00:00:18.490><c> yet</c><00:00:18.700><c> another</c><00:00:18.939><c> way</c><00:00:19.150><c> to</c><00:00:19.180><c> visualize</c><00:00:19.720><c> your</c>

00:00:19.890 --> 00:00:19.900 align:start position:0%
offers yet another way to visualize your
 

00:00:19.900 --> 00:00:22.019 align:start position:0%
offers yet another way to visualize your
data<00:00:19.960><c> using</c><00:00:20.919><c> things</c><00:00:21.099><c> like</c><00:00:21.220><c> color</c><00:00:21.580><c> coding</c>

00:00:22.019 --> 00:00:22.029 align:start position:0%
data using things like color coding
 

00:00:22.029 --> 00:00:25.290 align:start position:0%
data using things like color coding
based<00:00:22.270><c> on</c><00:00:22.480><c> the</c><00:00:22.570><c> cells</c><00:00:22.810><c> value</c><00:00:23.230><c> in</c><00:00:23.880><c> this</c><00:00:24.880><c> example</c>

00:00:25.290 --> 00:00:25.300 align:start position:0%
based on the cells value in this example
 

00:00:25.300 --> 00:00:27.330 align:start position:0%
based on the cells value in this example
I<00:00:25.599><c> have</c><00:00:25.930><c> the</c><00:00:26.050><c> sales</c><00:00:26.230><c> figures</c><00:00:26.679><c> for</c><00:00:26.949><c> a</c><00:00:26.980><c> number</c><00:00:27.250><c> of</c>

00:00:27.330 --> 00:00:27.340 align:start position:0%
I have the sales figures for a number of
 

00:00:27.340 --> 00:00:28.980 align:start position:0%
I have the sales figures for a number of
different<00:00:27.670><c> salespeople</c><00:00:28.119><c> and</c><00:00:28.480><c> I'd</c><00:00:28.810><c> like</c><00:00:28.929><c> to</c>

00:00:28.980 --> 00:00:28.990 align:start position:0%
different salespeople and I'd like to
 

00:00:28.990 --> 00:00:30.300 align:start position:0%
different salespeople and I'd like to
find<00:00:29.289><c> out</c><00:00:29.439><c> who's</c><00:00:29.650><c> meeting</c><00:00:30.039><c> or</c><00:00:30.220><c> exceeding</c>

00:00:30.300 --> 00:00:30.310 align:start position:0%
find out who's meeting or exceeding
 

00:00:30.310 --> 00:00:33.270 align:start position:0%
find out who's meeting or exceeding
their<00:00:30.849><c> monthly</c><00:00:31.090><c> sales</c><00:00:31.390><c> goal</c><00:00:31.660><c> of</c><00:00:32.070><c> course</c><00:00:33.070><c> we</c>

00:00:33.270 --> 00:00:33.280 align:start position:0%
their monthly sales goal of course we
 

00:00:33.280 --> 00:00:35.130 align:start position:0%
their monthly sales goal of course we
could<00:00:33.519><c> just</c><00:00:33.760><c> look</c><00:00:33.940><c> at</c><00:00:34.059><c> the</c><00:00:34.150><c> numbers</c><00:00:34.510><c> but</c><00:00:34.720><c> it</c>

00:00:35.130 --> 00:00:35.140 align:start position:0%
could just look at the numbers but it
 

00:00:35.140 --> 00:00:36.869 align:start position:0%
could just look at the numbers but it
might<00:00:35.320><c> be</c><00:00:35.440><c> easier</c><00:00:35.860><c> if</c><00:00:35.920><c> they</c><00:00:36.250><c> were</c><00:00:36.309><c> highlighted</c>

00:00:36.869 --> 00:00:36.879 align:start position:0%
might be easier if they were highlighted
 

00:00:36.879 --> 00:00:38.790 align:start position:0%
might be easier if they were highlighted
somehow<00:00:37.210><c> which</c><00:00:37.750><c> we</c><00:00:37.930><c> can</c><00:00:38.110><c> do</c><00:00:38.260><c> using</c><00:00:38.710><c> a</c>

00:00:38.790 --> 00:00:38.800 align:start position:0%
somehow which we can do using a
 

00:00:38.800 --> 00:00:42.329 align:start position:0%
somehow which we can do using a
conditional<00:00:39.339><c> formatting</c><00:00:39.760><c> rule</c><00:00:40.739><c> first</c><00:00:41.739><c> select</c>

00:00:42.329 --> 00:00:42.339 align:start position:0%
conditional formatting rule first select
 

00:00:42.339 --> 00:00:45.750 align:start position:0%
conditional formatting rule first select
your<00:00:42.430><c> data</c><00:00:44.070><c> then</c><00:00:45.070><c> go</c><00:00:45.370><c> to</c><00:00:45.430><c> conditional</c>

00:00:45.750 --> 00:00:45.760 align:start position:0%
your data then go to conditional
 

00:00:45.760 --> 00:00:50.220 align:start position:0%
your data then go to conditional
formatting<00:00:46.539><c> on</c><00:00:46.809><c> the</c><00:00:46.930><c> Home</c><00:00:47.079><c> tab</c><00:00:48.660><c> next</c><00:00:49.660><c> mouse</c>

00:00:50.220 --> 00:00:50.230 align:start position:0%
formatting on the Home tab next mouse
 

00:00:50.230 --> 00:00:53.040 align:start position:0%
formatting on the Home tab next mouse
over<00:00:50.649><c> highlight</c><00:00:51.100><c> cells</c><00:00:51.399><c> rules</c><00:00:51.520><c> and</c><00:00:52.030><c> in</c><00:00:52.899><c> this</c>

00:00:53.040 --> 00:00:53.050 align:start position:0%
over highlight cells rules and in this
 

00:00:53.050 --> 00:00:56.330 align:start position:0%
over highlight cells rules and in this
case<00:00:53.320><c> we're</c><00:00:53.559><c> going</c><00:00:53.739><c> to</c><00:00:53.829><c> choose</c><00:00:54.039><c> greater</c><00:00:54.489><c> than</c>

00:00:56.330 --> 00:00:56.340 align:start position:0%
case we're going to choose greater than
 

00:00:56.340 --> 00:00:58.889 align:start position:0%
case we're going to choose greater than
now<00:00:57.340><c> the</c><00:00:57.399><c> sales</c><00:00:57.789><c> goal</c><00:00:58.030><c> for</c><00:00:58.239><c> each</c><00:00:58.359><c> person</c><00:00:58.840><c> on</c>

00:00:58.889 --> 00:00:58.899 align:start position:0%
now the sales goal for each person on
 

00:00:58.899 --> 00:01:02.160 align:start position:0%
now the sales goal for each person on
this<00:00:59.109><c> list</c><00:00:59.379><c> is</c><00:00:59.699><c> $4,000</c><00:01:00.699><c> per</c><00:01:00.879><c> month</c><00:01:01.090><c> if</c><00:01:01.329><c> we</c>

00:01:02.160 --> 00:01:02.170 align:start position:0%
this list is $4,000 per month if we
 

00:01:02.170 --> 00:01:04.650 align:start position:0%
this list is $4,000 per month if we
enter<00:01:02.500><c> that</c><00:01:02.649><c> number</c><00:01:02.829><c> here</c><00:01:03.309><c> you</c><00:01:04.119><c> can</c><00:01:04.330><c> see</c><00:01:04.509><c> in</c>

00:01:04.650 --> 00:01:04.660 align:start position:0%
enter that number here you can see in
 

00:01:04.660 --> 00:01:06.300 align:start position:0%
enter that number here you can see in
the<00:01:04.750><c> background</c><00:01:04.960><c> that</c><00:01:05.500><c> any</c><00:01:05.710><c> cell</c><00:01:06.039><c> greater</c>

00:01:06.300 --> 00:01:06.310 align:start position:0%
the background that any cell greater
 

00:01:06.310 --> 00:01:08.130 align:start position:0%
the background that any cell greater
than<00:01:06.550><c> 4,000</c><00:01:07.300><c> is</c><00:01:07.450><c> being</c><00:01:07.750><c> formatted</c>

00:01:08.130 --> 00:01:08.140 align:start position:0%
than 4,000 is being formatted
 

00:01:08.140 --> 00:01:11.999 align:start position:0%
than 4,000 is being formatted
automatically<00:01:08.950><c> if</c><00:01:09.990><c> you</c><00:01:10.990><c> want</c><00:01:11.229><c> you</c><00:01:11.619><c> can</c><00:01:11.770><c> even</c>

00:01:11.999 --> 00:01:12.009 align:start position:0%
automatically if you want you can even
 

00:01:12.009 --> 00:01:15.170 align:start position:0%
automatically if you want you can even
choose<00:01:12.190><c> a</c><00:01:12.250><c> different</c><00:01:12.490><c> formatting</c><00:01:13.000><c> option</c>

00:01:15.170 --> 00:01:15.180 align:start position:0%
choose a different formatting option
 

00:01:15.180 --> 00:01:20.850 align:start position:0%
choose a different formatting option
just<00:01:16.180><c> click</c><00:01:16.450><c> OK</c><00:01:16.780><c> when</c><00:01:16.930><c> you're</c><00:01:16.990><c> done</c><00:01:17.140><c> as</c><00:01:19.860><c> you</c>

00:01:20.850 --> 00:01:20.860 align:start position:0%
just click OK when you're done as you
 

00:01:20.860 --> 00:01:23.010 align:start position:0%
just click OK when you're done as you
can<00:01:21.040><c> see</c><00:01:21.250><c> the</c><00:01:21.520><c> formatted</c><00:01:22.060><c> cells</c><00:01:22.299><c> really</c><00:01:22.630><c> stand</c>

00:01:23.010 --> 00:01:23.020 align:start position:0%
can see the formatted cells really stand
 

00:01:23.020 --> 00:01:25.170 align:start position:0%
can see the formatted cells really stand
out<00:01:23.170><c> now</c><00:01:23.409><c> so</c><00:01:23.830><c> we</c><00:01:23.950><c> can</c><00:01:24.100><c> easily</c><00:01:24.340><c> tell</c><00:01:24.670><c> who's</c><00:01:24.939><c> met</c>

00:01:25.170 --> 00:01:25.180 align:start position:0%
out now so we can easily tell who's met
 

00:01:25.180 --> 00:01:26.399 align:start position:0%
out now so we can easily tell who's met
or<00:01:25.390><c> exceeded</c><00:01:25.420><c> their</c><00:01:25.990><c> goal</c>

00:01:26.399 --> 00:01:26.409 align:start position:0%
or exceeded their goal
 

00:01:26.409 --> 00:01:28.710 align:start position:0%
or exceeded their goal
looks<00:01:27.369><c> like</c><00:01:27.579><c> August</c><00:01:28.000><c> wasn't</c><00:01:28.329><c> a</c><00:01:28.360><c> very</c><00:01:28.540><c> good</c>

00:01:28.710 --> 00:01:28.720 align:start position:0%
looks like August wasn't a very good
 

00:01:28.720 --> 00:01:30.749 align:start position:0%
looks like August wasn't a very good
month<00:01:28.900><c> for</c><00:01:29.020><c> example</c><00:01:29.229><c> but</c><00:01:30.100><c> September</c><00:01:30.369><c> and</c>

00:01:30.749 --> 00:01:30.759 align:start position:0%
month for example but September and
 

00:01:30.759 --> 00:01:35.819 align:start position:0%
month for example but September and
October<00:01:30.820><c> were</c><00:01:31.360><c> much</c><00:01:31.630><c> much</c><00:01:31.869><c> better</c><00:01:34.500><c> next</c><00:01:35.500><c> let's</c>

00:01:35.819 --> 00:01:35.829 align:start position:0%
October were much much better next let's
 

00:01:35.829 --> 00:01:37.350 align:start position:0%
October were much much better next let's
take<00:01:36.009><c> a</c><00:01:36.070><c> look</c><00:01:36.310><c> at</c><00:01:36.460><c> some</c><00:01:36.670><c> of</c><00:01:36.759><c> the</c><00:01:36.850><c> conditional</c>

00:01:37.350 --> 00:01:37.360 align:start position:0%
take a look at some of the conditional
 

00:01:37.360 --> 00:01:39.929 align:start position:0%
take a look at some of the conditional
formatting<00:01:37.780><c> presets</c><00:01:38.579><c> we're</c><00:01:39.579><c> just</c><00:01:39.759><c> going</c><00:01:39.909><c> to</c>

00:01:39.929 --> 00:01:39.939 align:start position:0%
formatting presets we're just going to
 

00:01:39.939 --> 00:01:43.620 align:start position:0%
formatting presets we're just going to
reselect<00:01:40.450><c> our</c><00:01:40.659><c> data</c><00:01:40.899><c> and</c><00:01:42.060><c> then</c><00:01:43.060><c> go</c><00:01:43.240><c> back</c><00:01:43.450><c> to</c>

00:01:43.620 --> 00:01:43.630 align:start position:0%
reselect our data and then go back to
 

00:01:43.630 --> 00:01:47.010 align:start position:0%
reselect our data and then go back to
the<00:01:43.720><c> conditional</c><00:01:44.229><c> formatting</c><00:01:44.619><c> command</c><00:01:46.020><c> you</c>

00:01:47.010 --> 00:01:47.020 align:start position:0%
the conditional formatting command you
 

00:01:47.020 --> 00:01:48.810 align:start position:0%
the conditional formatting command you
have<00:01:47.229><c> three</c><00:01:47.500><c> different</c><00:01:47.619><c> types</c><00:01:48.009><c> of</c><00:01:48.189><c> presets</c><00:01:48.579><c> to</c>

00:01:48.810 --> 00:01:48.820 align:start position:0%
have three different types of presets to
 

00:01:48.820 --> 00:01:51.600 align:start position:0%
have three different types of presets to
choose<00:01:48.850><c> from</c><00:01:49.360><c> data</c><00:01:50.110><c> bars</c><00:01:50.380><c> color</c><00:01:50.979><c> scales</c><00:01:51.340><c> and</c>

00:01:51.600 --> 00:01:51.610 align:start position:0%
choose from data bars color scales and
 

00:01:51.610 --> 00:01:54.179 align:start position:0%
choose from data bars color scales and
icon<00:01:52.149><c> sets</c><00:01:52.420><c> to</c><00:01:53.409><c> learn</c><00:01:53.590><c> more</c><00:01:53.799><c> about</c><00:01:53.890><c> each</c><00:01:54.159><c> one</c>

00:01:54.179 --> 00:01:54.189 align:start position:0%
icon sets to learn more about each one
 

00:01:54.189 --> 00:01:57.800 align:start position:0%
icon sets to learn more about each one
mouse<00:01:54.939><c> over</c><00:01:55.240><c> the</c><00:01:55.329><c> options</c><00:01:55.479><c> in</c><00:01:55.930><c> the</c><00:01:55.990><c> menu</c>

00:01:57.800 --> 00:01:57.810 align:start position:0%
mouse over the options in the menu
 

00:01:57.810 --> 00:02:00.240 align:start position:0%
mouse over the options in the menu
data<00:01:58.810><c> bars</c><00:01:59.079><c> are</c><00:01:59.320><c> kind</c><00:01:59.530><c> of</c><00:01:59.619><c> like</c><00:01:59.740><c> bar</c><00:01:59.979><c> graphs</c>

00:02:00.240 --> 00:02:00.250 align:start position:0%
data bars are kind of like bar graphs
 

00:02:00.250 --> 00:02:02.609 align:start position:0%
data bars are kind of like bar graphs
the<00:02:00.880><c> higher</c><00:02:01.090><c> the</c><00:02:01.299><c> value</c><00:02:01.450><c> the</c><00:02:01.689><c> longer</c><00:02:02.350><c> the</c><00:02:02.439><c> bar</c>

00:02:02.609 --> 00:02:02.619 align:start position:0%
the higher the value the longer the bar
 

00:02:02.619 --> 00:02:05.999 align:start position:0%
the higher the value the longer the bar
in<00:02:02.740><c> the</c><00:02:02.860><c> cell</c><00:02:04.170><c> color</c><00:02:05.170><c> scales</c><00:02:05.530><c> on</c><00:02:05.740><c> the</c><00:02:05.860><c> other</c>

00:02:05.999 --> 00:02:06.009 align:start position:0%
in the cell color scales on the other
 

00:02:06.009 --> 00:02:07.649 align:start position:0%
in the cell color scales on the other
hand<00:02:06.310><c> will</c><00:02:06.580><c> change</c><00:02:06.880><c> the</c><00:02:07.030><c> background</c><00:02:07.450><c> color</c>

00:02:07.649 --> 00:02:07.659 align:start position:0%
hand will change the background color
 

00:02:07.659 --> 00:02:12.390 align:start position:0%
hand will change the background color
based<00:02:07.990><c> on</c><00:02:08.170><c> the</c><00:02:08.319><c> cells</c><00:02:08.530><c> value</c><00:02:10.830><c> icon</c><00:02:11.830><c> sets</c><00:02:12.130><c> can</c>

00:02:12.390 --> 00:02:12.400 align:start position:0%
based on the cells value icon sets can
 

00:02:12.400 --> 00:02:14.309 align:start position:0%
based on the cells value icon sets can
be<00:02:12.520><c> used</c><00:02:12.730><c> to</c><00:02:12.849><c> add</c><00:02:12.970><c> different</c><00:02:13.209><c> symbols</c><00:02:13.810><c> ratings</c>

00:02:14.309 --> 00:02:14.319 align:start position:0%
be used to add different symbols ratings
 

00:02:14.319 --> 00:02:16.830 align:start position:0%
be used to add different symbols ratings
and<00:02:14.500><c> indicators</c><00:02:15.040><c> and</c><00:02:15.400><c> you</c><00:02:16.269><c> have</c><00:02:16.420><c> quite</c><00:02:16.750><c> a</c><00:02:16.780><c> few</c>

00:02:16.830 --> 00:02:16.840 align:start position:0%
and indicators and you have quite a few
 

00:02:16.840 --> 00:02:18.750 align:start position:0%
and indicators and you have quite a few
styles<00:02:17.380><c> to</c><00:02:17.500><c> choose</c><00:02:17.530><c> from</c><00:02:17.769><c> depending</c><00:02:18.220><c> on</c><00:02:18.610><c> what</c>

00:02:18.750 --> 00:02:18.760 align:start position:0%
styles to choose from depending on what
 

00:02:18.760 --> 00:02:22.259 align:start position:0%
styles to choose from depending on what
you<00:02:18.849><c> need</c><00:02:19.060><c> I</c><00:02:20.730><c> think</c><00:02:21.730><c> this</c><00:02:21.880><c> one's</c><00:02:22.120><c> especially</c>

00:02:22.259 --> 00:02:22.269 align:start position:0%
you need I think this one's especially
 

00:02:22.269 --> 00:02:28.350 align:start position:0%
you need I think this one's especially
easy<00:02:22.870><c> to</c><00:02:23.080><c> read</c><00:02:26.160><c> the</c><00:02:27.160><c> icons</c><00:02:27.580><c> will</c><00:02:27.760><c> help</c><00:02:28.000><c> us</c><00:02:28.150><c> see</c>

00:02:28.350 --> 00:02:28.360 align:start position:0%
easy to read the icons will help us see
 

00:02:28.360 --> 00:02:30.720 align:start position:0%
easy to read the icons will help us see
which<00:02:28.569><c> items</c><00:02:28.900><c> are</c><00:02:29.050><c> the</c><00:02:29.200><c> highest</c><00:02:29.560><c> and</c><00:02:29.830><c> also</c><00:02:30.549><c> the</c>

00:02:30.720 --> 00:02:30.730 align:start position:0%
which items are the highest and also the
 

00:02:30.730 --> 00:02:33.300 align:start position:0%
which items are the highest and also the
lowest<00:02:30.910><c> when</c><00:02:31.450><c> compared</c><00:02:31.870><c> to</c><00:02:31.930><c> each</c><00:02:32.140><c> other</c><00:02:32.350><c> we</c>

00:02:33.300 --> 00:02:33.310 align:start position:0%
lowest when compared to each other we
 

00:02:33.310 --> 00:02:34.860 align:start position:0%
lowest when compared to each other we
can<00:02:33.459><c> also</c><00:02:33.640><c> see</c><00:02:34.030><c> which</c><00:02:34.239><c> ones</c><00:02:34.480><c> are</c><00:02:34.630><c> about</c>

00:02:34.860 --> 00:02:34.870 align:start position:0%
can also see which ones are about
 

00:02:34.870 --> 00:02:38.280 align:start position:0%
can also see which ones are about
average<00:02:36.330><c> you</c><00:02:37.330><c> might</c><00:02:37.540><c> have</c><00:02:37.660><c> noticed</c><00:02:38.019><c> that</c><00:02:38.110><c> the</c>

00:02:38.280 --> 00:02:38.290 align:start position:0%
average you might have noticed that the
 

00:02:38.290 --> 00:02:39.990 align:start position:0%
average you might have noticed that the
first<00:02:38.470><c> rule</c><00:02:38.769><c> we</c><00:02:38.890><c> applied</c><00:02:39.190><c> is</c><00:02:39.370><c> still</c><00:02:39.610><c> visible</c>

00:02:39.990 --> 00:02:40.000 align:start position:0%
first rule we applied is still visible
 

00:02:40.000 --> 00:02:41.940 align:start position:0%
first rule we applied is still visible
the<00:02:40.600><c> one</c><00:02:40.780><c> that's</c><00:02:40.989><c> changing</c><00:02:41.380><c> the</c><00:02:41.500><c> fill</c><00:02:41.680><c> color</c>

00:02:41.940 --> 00:02:41.950 align:start position:0%
the one that's changing the fill color
 

00:02:41.950 --> 00:02:44.940 align:start position:0%
the one that's changing the fill color
for<00:02:42.040><c> cells</c><00:02:42.459><c> above</c><00:02:42.790><c> 4,000</c><00:02:43.540><c> that's</c><00:02:44.530><c> because</c>

00:02:44.940 --> 00:02:44.950 align:start position:0%
for cells above 4,000 that's because
 

00:02:44.950 --> 00:02:46.860 align:start position:0%
for cells above 4,000 that's because
Excel<00:02:45.310><c> lets</c><00:02:45.549><c> you</c><00:02:45.670><c> have</c><00:02:45.819><c> multiple</c><00:02:45.870><c> conditional</c>

00:02:46.860 --> 00:02:46.870 align:start position:0%
Excel lets you have multiple conditional
 

00:02:46.870 --> 00:02:49.110 align:start position:0%
Excel lets you have multiple conditional
formatting<00:02:47.290><c> rules</c><00:02:47.620><c> at</c><00:02:47.860><c> the</c><00:02:48.010><c> same</c><00:02:48.250><c> time</c><00:02:48.580><c> so</c><00:02:49.060><c> you</c>

00:02:49.110 --> 00:02:49.120 align:start position:0%
formatting rules at the same time so you
 

00:02:49.120 --> 00:02:52.410 align:start position:0%
formatting rules at the same time so you
can<00:02:49.360><c> highlight</c><00:02:49.569><c> different</c><00:02:50.080><c> things</c><00:02:51.150><c> to</c><00:02:52.150><c> clear</c>

00:02:52.410 --> 00:02:52.420 align:start position:0%
can highlight different things to clear
 

00:02:52.420 --> 00:02:54.420 align:start position:0%
can highlight different things to clear
the<00:02:52.540><c> current</c><00:02:52.690><c> formatting</c><00:02:53.319><c> rules</c><00:02:53.530><c> just</c><00:02:54.069><c> select</c>

00:02:54.420 --> 00:02:54.430 align:start position:0%
the current formatting rules just select
 

00:02:54.430 --> 00:02:57.630 align:start position:0%
the current formatting rules just select
your<00:02:54.519><c> cells</c><00:02:56.099><c> then</c><00:02:57.099><c> go</c><00:02:57.340><c> to</c><00:02:57.400><c> conditional</c>

00:02:57.630 --> 00:02:57.640 align:start position:0%
your cells then go to conditional
 

00:02:57.640 --> 00:03:01.410 align:start position:0%
your cells then go to conditional
formatting<00:02:58.420><c> and</c><00:02:59.580><c> mouse</c><00:03:00.580><c> over</c><00:03:00.910><c> the</c><00:03:01.000><c> option</c>

00:03:01.410 --> 00:03:01.420 align:start position:0%
formatting and mouse over the option
 

00:03:01.420 --> 00:03:03.990 align:start position:0%
formatting and mouse over the option
that<00:03:01.450><c> says</c><00:03:01.600><c> clear</c><00:03:02.170><c> rules</c><00:03:02.500><c> you</c><00:03:03.459><c> can</c><00:03:03.609><c> clear</c><00:03:03.880><c> the</c>

00:03:03.990 --> 00:03:04.000 align:start position:0%
that says clear rules you can clear the
 

00:03:04.000 --> 00:03:06.830 align:start position:0%
that says clear rules you can clear the
selected<00:03:04.480><c> cells</c><00:03:04.750><c> or</c><00:03:05.019><c> the</c><00:03:05.440><c> entire</c><00:03:05.769><c> sheet</c><00:03:06.100><c> in</c>

00:03:06.830 --> 00:03:06.840 align:start position:0%
selected cells or the entire sheet in
 

00:03:06.840 --> 00:03:09.780 align:start position:0%
selected cells or the entire sheet in
this<00:03:07.840><c> case</c><00:03:08.079><c> though</c><00:03:08.350><c> I'd</c><00:03:08.590><c> just</c><00:03:09.160><c> like</c><00:03:09.340><c> to</c><00:03:09.489><c> remove</c>

00:03:09.780 --> 00:03:09.790 align:start position:0%
this case though I'd just like to remove
 

00:03:09.790 --> 00:03:12.030 align:start position:0%
this case though I'd just like to remove
the<00:03:09.970><c> greater</c><00:03:10.180><c> than</c><00:03:10.420><c> 4000</c><00:03:11.079><c> rule</c><00:03:11.290><c> while</c><00:03:11.680><c> keeping</c>

00:03:12.030 --> 00:03:12.040 align:start position:0%
the greater than 4000 rule while keeping
 

00:03:12.040 --> 00:03:15.030 align:start position:0%
the greater than 4000 rule while keeping
the<00:03:12.160><c> rest</c><00:03:12.340><c> of</c><00:03:12.519><c> the</c><00:03:12.609><c> icons</c><00:03:13.170><c> we</c><00:03:14.170><c> can</c><00:03:14.350><c> do</c><00:03:14.530><c> that</c><00:03:14.739><c> by</c>

00:03:15.030 --> 00:03:15.040 align:start position:0%
the rest of the icons we can do that by
 

00:03:15.040 --> 00:03:18.199 align:start position:0%
the rest of the icons we can do that by
going<00:03:15.190><c> to</c><00:03:15.370><c> manage</c><00:03:15.850><c> rules</c><00:03:16.060><c> instead</c>

00:03:18.199 --> 00:03:18.209 align:start position:0%
going to manage rules instead
 

00:03:18.209 --> 00:03:20.610 align:start position:0%
going to manage rules instead
here<00:03:19.209><c> you'll</c><00:03:19.359><c> find</c><00:03:19.420><c> a</c><00:03:19.689><c> list</c><00:03:19.870><c> of</c><00:03:20.019><c> all</c><00:03:20.260><c> the</c><00:03:20.409><c> rules</c>

00:03:20.610 --> 00:03:20.620 align:start position:0%
here you'll find a list of all the rules
 

00:03:20.620 --> 00:03:22.429 align:start position:0%
here you'll find a list of all the rules
that<00:03:20.739><c> are</c><00:03:20.950><c> currently</c><00:03:21.250><c> applied</c><00:03:21.430><c> to</c><00:03:21.819><c> your</c><00:03:21.909><c> cells</c>

00:03:22.429 --> 00:03:22.439 align:start position:0%
that are currently applied to your cells
 

00:03:22.439 --> 00:03:25.289 align:start position:0%
that are currently applied to your cells
to<00:03:23.439><c> remove</c><00:03:23.739><c> one</c><00:03:24.010><c> just</c><00:03:24.489><c> select</c><00:03:24.819><c> the</c><00:03:24.969><c> rule</c><00:03:25.150><c> you</c>

00:03:25.289 --> 00:03:25.299 align:start position:0%
to remove one just select the rule you
 

00:03:25.299 --> 00:03:34.759 align:start position:0%
to remove one just select the rule you
want<00:03:26.549><c> then</c><00:03:27.549><c> click</c><00:03:27.579><c> delete</c><00:03:28.060><c> rule</c><00:03:28.480><c> and</c><00:03:30.390><c> click</c><00:03:31.390><c> OK</c>

00:03:34.759 --> 00:03:34.769 align:start position:0%
 
 

00:03:34.769 --> 00:03:37.020 align:start position:0%
 
conditional<00:03:35.769><c> formatting</c><00:03:36.219><c> is</c><00:03:36.459><c> a</c><00:03:36.489><c> great</c><00:03:36.790><c> tool</c>

00:03:37.020 --> 00:03:37.030 align:start position:0%
conditional formatting is a great tool
 

00:03:37.030 --> 00:03:38.849 align:start position:0%
conditional formatting is a great tool
for<00:03:37.329><c> visualizing</c><00:03:37.480><c> parts</c><00:03:38.230><c> of</c><00:03:38.349><c> your</c><00:03:38.469><c> worksheet</c>

00:03:38.849 --> 00:03:38.859 align:start position:0%
for visualizing parts of your worksheet
 

00:03:38.859 --> 00:03:41.220 align:start position:0%
for visualizing parts of your worksheet
so<00:03:39.790><c> practice</c><00:03:40.180><c> using</c><00:03:40.480><c> some</c><00:03:40.659><c> of</c><00:03:40.780><c> the</c><00:03:40.840><c> rules</c><00:03:41.019><c> on</c>

00:03:41.220 --> 00:03:41.230 align:start position:0%
so practice using some of the rules on
 

00:03:41.230 --> 00:03:43.500 align:start position:0%
so practice using some of the rules on
your<00:03:41.319><c> own</c><00:03:41.530><c> and</c><00:03:41.739><c> try</c><00:03:42.189><c> combining</c><00:03:42.790><c> them</c><00:03:42.939><c> to</c><00:03:43.329><c> see</c>

00:03:43.500 --> 00:03:43.510 align:start position:0%
your own and try combining them to see
 

00:03:43.510 --> 00:03:46.950 align:start position:0%
your own and try combining them to see
what<00:03:43.629><c> they</c><00:03:43.750><c> can</c><00:03:43.810><c> tell</c><00:03:44.079><c> you</c><00:03:44.200><c> about</c><00:03:44.319><c> your</c><00:03:44.680><c> data</c>