WEBVTT
Kind: captions
Language: en

00:00:01.149 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.149><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:08.030 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.760><c> life</c>

00:00:08.030 --> 00:00:08.040 align:start position:0%
 
 

00:00:08.040 --> 00:00:09.710 align:start position:0%
 
you<00:00:08.700><c> may</c><00:00:08.850><c> already</c><00:00:09.030><c> have</c><00:00:09.270><c> some</c><00:00:09.450><c> experience</c>

00:00:09.710 --> 00:00:09.720 align:start position:0%
you may already have some experience
 

00:00:09.720 --> 00:00:12.910 align:start position:0%
you may already have some experience
using<00:00:10.500><c> charts</c><00:00:10.920><c> to</c><00:00:11.490><c> visualize</c><00:00:11.970><c> data</c><00:00:12.000><c> in</c><00:00:12.450><c> Excel</c>

00:00:12.910 --> 00:00:12.920 align:start position:0%
using charts to visualize data in Excel
 

00:00:12.920 --> 00:00:15.799 align:start position:0%
using charts to visualize data in Excel
conditional<00:00:13.920><c> formatting</c><00:00:14.760><c> offers</c><00:00:15.480><c> another</c>

00:00:15.799 --> 00:00:15.809 align:start position:0%
conditional formatting offers another
 

00:00:15.809 --> 00:00:18.140 align:start position:0%
conditional formatting offers another
way<00:00:16.020><c> to</c><00:00:16.080><c> visualize</c><00:00:16.260><c> your</c><00:00:16.710><c> data</c><00:00:16.950><c> using</c><00:00:17.670><c> options</c>

00:00:18.140 --> 00:00:18.150 align:start position:0%
way to visualize your data using options
 

00:00:18.150 --> 00:00:20.150 align:start position:0%
way to visualize your data using options
like<00:00:18.360><c> color</c><00:00:18.630><c> coding</c><00:00:19.110><c> based</c><00:00:19.650><c> on</c><00:00:19.860><c> the</c><00:00:19.950><c> cells</c>

00:00:20.150 --> 00:00:20.160 align:start position:0%
like color coding based on the cells
 

00:00:20.160 --> 00:00:23.720 align:start position:0%
like color coding based on the cells
value<00:00:20.610><c> in</c><00:00:21.290><c> this</c><00:00:22.290><c> example</c><00:00:22.680><c> I</c><00:00:23.010><c> have</c><00:00:23.160><c> the</c><00:00:23.520><c> sales</c>

00:00:23.720 --> 00:00:23.730 align:start position:0%
value in this example I have the sales
 

00:00:23.730 --> 00:00:25.160 align:start position:0%
value in this example I have the sales
figures<00:00:24.240><c> for</c><00:00:24.270><c> a</c><00:00:24.539><c> group</c><00:00:24.840><c> of</c><00:00:24.990><c> different</c>

00:00:25.160 --> 00:00:25.170 align:start position:0%
figures for a group of different
 

00:00:25.170 --> 00:00:26.060 align:start position:0%
figures for a group of different
salespeople

00:00:26.060 --> 00:00:26.070 align:start position:0%
salespeople
 

00:00:26.070 --> 00:00:28.010 align:start position:0%
salespeople
and<00:00:26.220><c> I'd</c><00:00:26.640><c> like</c><00:00:26.820><c> to</c><00:00:26.880><c> find</c><00:00:27.240><c> out</c><00:00:27.420><c> who's</c><00:00:27.720><c> meeting</c>

00:00:28.010 --> 00:00:28.020 align:start position:0%
and I'd like to find out who's meeting
 

00:00:28.020 --> 00:00:30.439 align:start position:0%
and I'd like to find out who's meeting
or<00:00:28.380><c> exceeding</c><00:00:28.650><c> their</c><00:00:29.280><c> monthly</c><00:00:29.550><c> sales</c><00:00:29.880><c> goal</c><00:00:30.210><c> of</c>

00:00:30.439 --> 00:00:30.449 align:start position:0%
or exceeding their monthly sales goal of
 

00:00:30.449 --> 00:00:32.810 align:start position:0%
or exceeding their monthly sales goal of
course<00:00:31.320><c> we</c><00:00:31.680><c> could</c><00:00:31.830><c> just</c><00:00:32.010><c> look</c><00:00:32.220><c> at</c><00:00:32.340><c> the</c><00:00:32.460><c> numbers</c>

00:00:32.810 --> 00:00:32.820 align:start position:0%
course we could just look at the numbers
 

00:00:32.820 --> 00:00:34.729 align:start position:0%
course we could just look at the numbers
but<00:00:33.210><c> it</c><00:00:33.420><c> might</c><00:00:33.870><c> be</c><00:00:34.020><c> easier</c><00:00:34.350><c> if</c><00:00:34.410><c> they</c><00:00:34.680><c> were</c>

00:00:34.729 --> 00:00:34.739 align:start position:0%
but it might be easier if they were
 

00:00:34.739 --> 00:00:37.220 align:start position:0%
but it might be easier if they were
highlighted<00:00:35.430><c> somehow</c><00:00:35.790><c> and</c><00:00:36.059><c> the</c><00:00:36.720><c> good</c><00:00:36.900><c> news</c><00:00:37.080><c> is</c>

00:00:37.220 --> 00:00:37.230 align:start position:0%
highlighted somehow and the good news is
 

00:00:37.230 --> 00:00:39.560 align:start position:0%
highlighted somehow and the good news is
that<00:00:37.260><c> we</c><00:00:37.530><c> can</c><00:00:37.680><c> actually</c><00:00:37.860><c> do</c><00:00:38.280><c> just</c><00:00:38.760><c> that</c><00:00:39.000><c> with</c><00:00:39.270><c> a</c>

00:00:39.560 --> 00:00:39.570 align:start position:0%
that we can actually do just that with a
 

00:00:39.570 --> 00:00:42.829 align:start position:0%
that we can actually do just that with a
conditional<00:00:40.140><c> formatting</c><00:00:40.530><c> rule</c><00:00:41.059><c> first</c><00:00:42.059><c> select</c>

00:00:42.829 --> 00:00:42.839 align:start position:0%
conditional formatting rule first select
 

00:00:42.839 --> 00:00:45.229 align:start position:0%
conditional formatting rule first select
your<00:00:43.019><c> data</c><00:00:43.640><c> then</c><00:00:44.640><c> go</c><00:00:44.909><c> to</c><00:00:44.970><c> conditional</c>

00:00:45.229 --> 00:00:45.239 align:start position:0%
your data then go to conditional
 

00:00:45.239 --> 00:00:48.740 align:start position:0%
your data then go to conditional
formatting<00:00:46.140><c> on</c><00:00:46.350><c> the</c><00:00:46.500><c> Home</c><00:00:46.680><c> tab</c><00:00:47.300><c> next</c><00:00:48.300><c> mouse</c>

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

00:00:48.750 --> 00:00:51.590 align:start position:0%
formatting on the Home tab next mouse
over<00:00:49.140><c> highlight</c><00:00:49.860><c> cells</c><00:00:50.159><c> rules</c><00:00:50.339><c> and</c><00:00:50.879><c> in</c><00:00:51.479><c> this</c>

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

00:00:51.600 --> 00:00:53.979 align:start position:0%
over highlight cells rules and in this
case<00:00:51.870><c> we're</c><00:00:52.140><c> going</c><00:00:52.290><c> to</c><00:00:52.440><c> choose</c><00:00:52.589><c> greater</c><00:00:53.370><c> ban</c>

00:00:53.979 --> 00:00:53.989 align:start position:0%
case we're going to choose greater ban
 

00:00:53.989 --> 00:00:56.719 align:start position:0%
case we're going to choose greater ban
now<00:00:54.989><c> the</c><00:00:55.049><c> sales</c><00:00:55.379><c> goal</c><00:00:55.739><c> for</c><00:00:55.979><c> each</c><00:00:56.159><c> person</c><00:00:56.670><c> on</c>

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

00:00:56.729 --> 00:01:00.410 align:start position:0%
now the sales goal for each person on
this<00:00:57.000><c> list</c><00:00:57.269><c> is</c><00:00:57.680><c> $4,000</c><00:00:58.680><c> per</c><00:00:58.890><c> month</c><00:00:59.100><c> if</c><00:00:59.309><c> we</c><00:01:00.030><c> type</c>

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

00:01:00.420 --> 00:01:02.450 align:start position:0%
this list is $4,000 per month if we type
that<00:01:00.449><c> number</c><00:01:00.750><c> here</c><00:01:01.379><c> you</c><00:01:01.920><c> can</c><00:01:02.100><c> see</c><00:01:02.280><c> in</c><00:01:02.370><c> the</c>

00:01:02.450 --> 00:01:02.460 align:start position:0%
that number here you can see in the
 

00:01:02.460 --> 00:01:04.460 align:start position:0%
that number here you can see in the
background<00:01:02.670><c> that</c><00:01:03.180><c> any</c><00:01:03.420><c> cell</c><00:01:03.780><c> with</c><00:01:04.080><c> a</c><00:01:04.110><c> value</c>

00:01:04.460 --> 00:01:04.470 align:start position:0%
background that any cell with a value
 

00:01:04.470 --> 00:01:06.770 align:start position:0%
background that any cell with a value
greater<00:01:04.830><c> than</c><00:01:04.949><c> 4,000</c><00:01:05.790><c> is</c><00:01:05.970><c> being</c><00:01:06.390><c> formatted</c>

00:01:06.770 --> 00:01:06.780 align:start position:0%
greater than 4,000 is being formatted
 

00:01:06.780 --> 00:01:09.950 align:start position:0%
greater than 4,000 is being formatted
automatically<00:01:07.650><c> if</c><00:01:07.850><c> you</c><00:01:08.850><c> want</c><00:01:09.119><c> you</c><00:01:09.690><c> can</c><00:01:09.840><c> even</c>

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

00:01:09.960 --> 00:01:12.850 align:start position:0%
automatically if you want you can even
choose<00:01:10.290><c> a</c><00:01:10.320><c> different</c><00:01:10.740><c> formatting</c><00:01:11.100><c> option</c>

00:01:12.850 --> 00:01:12.860 align:start position:0%
choose a different formatting option
 

00:01:12.860 --> 00:01:16.110 align:start position:0%
choose a different formatting option
just<00:01:13.700><c> click</c><00:01:13.940><c> ok</c><00:01:14.270><c> when</c><00:01:14.480><c> you're</c><00:01:14.600><c> done</c>

00:01:16.110 --> 00:01:16.120 align:start position:0%
just click ok when you're done
 

00:01:16.120 --> 00:01:18.630 align:start position:0%
just click ok when you're done
as<00:01:16.180><c> you</c><00:01:17.140><c> can</c><00:01:17.260><c> see</c><00:01:17.530><c> the</c><00:01:17.980><c> formatted</c><00:01:18.460><c> cells</c>

00:01:18.630 --> 00:01:18.640 align:start position:0%
as you can see the formatted cells
 

00:01:18.640 --> 00:01:20.970 align:start position:0%
as you can see the formatted cells
really<00:01:19.150><c> stand</c><00:01:19.570><c> out</c><00:01:19.750><c> now</c><00:01:20.020><c> so</c><00:01:20.470><c> we</c><00:01:20.560><c> can</c><00:01:20.710><c> easily</c>

00:01:20.970 --> 00:01:20.980 align:start position:0%
really stand out now so we can easily
 

00:01:20.980 --> 00:01:23.520 align:start position:0%
really stand out now so we can easily
tell<00:01:21.430><c> who's</c><00:01:21.730><c> met</c><00:01:22.060><c> or</c><00:01:22.270><c> exceeded</c><00:01:22.330><c> their</c><00:01:23.050><c> goal</c>

00:01:23.520 --> 00:01:23.530 align:start position:0%
tell who's met or exceeded their goal
 

00:01:23.530 --> 00:01:25.890 align:start position:0%
tell who's met or exceeded their goal
it<00:01:24.220><c> looks</c><00:01:24.430><c> like</c><00:01:24.580><c> August</c><00:01:25.000><c> wasn't</c><00:01:25.600><c> a</c><00:01:25.630><c> very</c><00:01:25.780><c> good</c>

00:01:25.890 --> 00:01:25.900 align:start position:0%
it looks like August wasn't a very good
 

00:01:25.900 --> 00:01:28.530 align:start position:0%
it looks like August wasn't a very good
month<00:01:26.320><c> for</c><00:01:26.560><c> example</c><00:01:26.800><c> but</c><00:01:27.610><c> September</c><00:01:28.420><c> and</c>

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

00:01:28.540 --> 00:01:31.730 align:start position:0%
month for example but September and
October<00:01:28.630><c> were</c><00:01:29.260><c> much</c><00:01:29.500><c> much</c><00:01:30.100><c> better</c>

00:01:31.730 --> 00:01:31.740 align:start position:0%
October were much much better
 

00:01:31.740 --> 00:01:34.100 align:start position:0%
October were much much better
next<00:01:32.670><c> let's</c><00:01:33.120><c> take</c><00:01:33.330><c> a</c><00:01:33.390><c> look</c><00:01:33.479><c> at</c><00:01:33.750><c> some</c><00:01:33.900><c> of</c><00:01:33.990><c> the</c>

00:01:34.100 --> 00:01:34.110 align:start position:0%
next let's take a look at some of the
 

00:01:34.110 --> 00:01:36.560 align:start position:0%
next let's take a look at some of the
conditional<00:01:34.619><c> formatting</c><00:01:34.650><c> presets</c><00:01:35.580><c> we're</c>

00:01:36.560 --> 00:01:36.570 align:start position:0%
conditional formatting presets we're
 

00:01:36.570 --> 00:01:39.320 align:start position:0%
conditional formatting presets we're
just<00:01:36.750><c> going</c><00:01:36.990><c> to</c><00:01:37.140><c> reselect</c><00:01:37.770><c> our</c><00:01:37.979><c> data</c><00:01:38.159><c> then</c><00:01:39.150><c> go</c>

00:01:39.320 --> 00:01:39.330 align:start position:0%
just going to reselect our data then go
 

00:01:39.330 --> 00:01:40.310 align:start position:0%
just going to reselect our data then go
back<00:01:39.510><c> to</c><00:01:39.690><c> the</c><00:01:39.780><c> conditional</c><00:01:40.290><c> formatting</c>

00:01:40.310 --> 00:01:40.320 align:start position:0%
back to the conditional formatting
 

00:01:40.320 --> 00:01:43.520 align:start position:0%
back to the conditional formatting
command<00:01:41.630><c> you</c><00:01:42.630><c> have</c><00:01:42.810><c> three</c><00:01:43.140><c> different</c><00:01:43.290><c> types</c>

00:01:43.520 --> 00:01:43.530 align:start position:0%
command you have three different types
 

00:01:43.530 --> 00:01:46.370 align:start position:0%
command you have three different types
of<00:01:43.920><c> presets</c><00:01:44.340><c> to</c><00:01:44.550><c> choose</c><00:01:44.790><c> from</c><00:01:45.090><c> data</c><00:01:46.080><c> bars</c>

00:01:46.370 --> 00:01:46.380 align:start position:0%
of presets to choose from data bars
 

00:01:46.380 --> 00:01:49.940 align:start position:0%
of presets to choose from data bars
color<00:01:47.040><c> scales</c><00:01:47.430><c> and</c><00:01:47.729><c> icon</c><00:01:48.360><c> sets</c><00:01:48.690><c> to</c><00:01:49.590><c> learn</c><00:01:49.740><c> more</c>

00:01:49.940 --> 00:01:49.950 align:start position:0%
color scales and icon sets to learn more
 

00:01:49.950 --> 00:01:52.399 align:start position:0%
color scales and icon sets to learn more
about<00:01:50.070><c> each</c><00:01:50.369><c> one</c><00:01:50.420><c> mouse</c><00:01:51.420><c> over</c><00:01:51.810><c> these</c><00:01:51.960><c> options</c>

00:01:52.399 --> 00:01:52.409 align:start position:0%
about each one mouse over these options
 

00:01:52.409 --> 00:01:55.430 align:start position:0%
about each one mouse over these options
in<00:01:52.560><c> the</c><00:01:52.649><c> menu</c><00:01:53.300><c> data</c><00:01:54.300><c> bars</c><00:01:54.600><c> are</c><00:01:54.899><c> kind</c><00:01:55.229><c> of</c><00:01:55.259><c> like</c>

00:01:55.430 --> 00:01:55.440 align:start position:0%
in the menu data bars are kind of like
 

00:01:55.440 --> 00:01:57.609 align:start position:0%
in the menu data bars are kind of like
bar<00:01:55.710><c> graphs</c><00:01:56.040><c> the</c><00:01:56.610><c> higher</c><00:01:56.820><c> the</c><00:01:57.060><c> value</c><00:01:57.210><c> the</c>

00:01:57.609 --> 00:01:57.619 align:start position:0%
bar graphs the higher the value the
 

00:01:57.619 --> 00:02:01.370 align:start position:0%
bar graphs the higher the value the
longer<00:01:58.619><c> the</c><00:01:58.770><c> bar</c><00:01:58.950><c> in</c><00:01:59.130><c> the</c><00:01:59.250><c> cell</c><00:01:59.899><c> color</c><00:02:00.899><c> scales</c>

00:02:01.370 --> 00:02:01.380 align:start position:0%
longer the bar in the cell color scales
 

00:02:01.380 --> 00:02:03.710 align:start position:0%
longer the bar in the cell color scales
on<00:02:01.680><c> the</c><00:02:02.009><c> other</c><00:02:02.130><c> hand</c><00:02:02.460><c> we'll</c><00:02:03.240><c> change</c><00:02:03.540><c> the</c>

00:02:03.710 --> 00:02:03.720 align:start position:0%
on the other hand we'll change the
 

00:02:03.720 --> 00:02:05.270 align:start position:0%
on the other hand we'll change the
background<00:02:04.140><c> color</c><00:02:04.350><c> based</c><00:02:04.710><c> on</c><00:02:04.890><c> the</c><00:02:05.009><c> cells</c>

00:02:05.270 --> 00:02:05.280 align:start position:0%
background color based on the cells
 

00:02:05.280 --> 00:02:08.449 align:start position:0%
background color based on the cells
value<00:02:06.320><c> icon</c><00:02:07.320><c> sets</c><00:02:07.619><c> can</c><00:02:07.890><c> be</c><00:02:07.950><c> used</c><00:02:08.250><c> to</c><00:02:08.399><c> add</c>

00:02:08.449 --> 00:02:08.459 align:start position:0%
value icon sets can be used to add
 

00:02:08.459 --> 00:02:10.699 align:start position:0%
value icon sets can be used to add
different<00:02:08.729><c> symbols</c><00:02:09.390><c> ratings</c><00:02:10.050><c> and</c><00:02:10.259><c> indicators</c>

00:02:10.699 --> 00:02:10.709 align:start position:0%
different symbols ratings and indicators
 

00:02:10.709 --> 00:02:13.070 align:start position:0%
different symbols ratings and indicators
and<00:02:11.070><c> you</c><00:02:11.760><c> have</c><00:02:11.880><c> quite</c><00:02:12.239><c> a</c><00:02:12.269><c> few</c><00:02:12.570><c> styles</c><00:02:12.930><c> to</c>

00:02:13.070 --> 00:02:13.080 align:start position:0%
and you have quite a few styles to
 

00:02:13.080 --> 00:02:15.550 align:start position:0%
and you have quite a few styles to
choose<00:02:13.110><c> from</c><00:02:13.380><c> depending</c><00:02:14.040><c> on</c><00:02:14.459><c> what</c><00:02:14.640><c> you</c><00:02:14.760><c> need</c><00:02:14.970><c> I</c>

00:02:15.550 --> 00:02:15.560 align:start position:0%
choose from depending on what you need I
 

00:02:15.560 --> 00:02:20.589 align:start position:0%
choose from depending on what you need I
think<00:02:16.560><c> this</c><00:02:17.070><c> one's</c><00:02:17.340><c> especially</c><00:02:17.670><c> easy</c><00:02:18.269><c> to</c><00:02:18.420><c> read</c>

00:02:20.589 --> 00:02:20.599 align:start position:0%
think this one's especially easy to read
 

00:02:20.599 --> 00:02:22.220 align:start position:0%
think this one's especially easy to read
these<00:02:21.349><c> icons</c><00:02:21.799><c> help</c>

00:02:22.220 --> 00:02:22.230 align:start position:0%
these icons help
 

00:02:22.230 --> 00:02:24.470 align:start position:0%
these icons help
see<00:02:22.349><c> which</c><00:02:22.650><c> items</c><00:02:23.040><c> are</c><00:02:23.159><c> the</c><00:02:23.280><c> highest</c><00:02:23.760><c> and</c><00:02:23.909><c> also</c>

00:02:24.470 --> 00:02:24.480 align:start position:0%
see which items are the highest and also
 

00:02:24.480 --> 00:02:26.300 align:start position:0%
see which items are the highest and also
the<00:02:24.599><c> lowest</c><00:02:25.050><c> when</c><00:02:25.290><c> compared</c><00:02:25.739><c> to</c><00:02:25.800><c> one</c><00:02:26.040><c> another</c>

00:02:26.300 --> 00:02:26.310 align:start position:0%
the lowest when compared to one another
 

00:02:26.310 --> 00:02:28.640 align:start position:0%
the lowest when compared to one another
we<00:02:27.180><c> can</c><00:02:27.330><c> also</c><00:02:27.480><c> see</c><00:02:27.810><c> which</c><00:02:28.080><c> ones</c><00:02:28.319><c> are</c><00:02:28.560><c> about</c>

00:02:28.640 --> 00:02:28.650 align:start position:0%
we can also see which ones are about
 

00:02:28.650 --> 00:02:31.580 align:start position:0%
we can also see which ones are about
average<00:02:29.599><c> now</c><00:02:30.599><c> you</c><00:02:30.659><c> might</c><00:02:31.019><c> have</c><00:02:31.110><c> noticed</c><00:02:31.500><c> that</c>

00:02:31.580 --> 00:02:31.590 align:start position:0%
average now you might have noticed that
 

00:02:31.590 --> 00:02:33.860 align:start position:0%
average now you might have noticed that
the<00:02:31.680><c> first</c><00:02:32.040><c> rule</c><00:02:32.430><c> we</c><00:02:32.670><c> apply</c><00:02:32.970><c> to</c><00:02:33.000><c> still</c><00:02:33.450><c> visible</c>

00:02:33.860 --> 00:02:33.870 align:start position:0%
the first rule we apply to still visible
 

00:02:33.870 --> 00:02:36.320 align:start position:0%
the first rule we apply to still visible
that's<00:02:34.799><c> the</c><00:02:35.040><c> one</c><00:02:35.190><c> that's</c><00:02:35.310><c> changing</c><00:02:35.970><c> the</c><00:02:36.120><c> fill</c>

00:02:36.320 --> 00:02:36.330 align:start position:0%
that's the one that's changing the fill
 

00:02:36.330 --> 00:02:39.350 align:start position:0%
that's the one that's changing the fill
color<00:02:36.599><c> for</c><00:02:36.989><c> cells</c><00:02:37.260><c> above</c><00:02:37.590><c> 4,000</c><00:02:38.310><c> and</c><00:02:39.180><c> that's</c>

00:02:39.350 --> 00:02:39.360 align:start position:0%
color for cells above 4,000 and that's
 

00:02:39.360 --> 00:02:40.750 align:start position:0%
color for cells above 4,000 and that's
because<00:02:39.720><c> Excel</c><00:02:40.080><c> lets</c><00:02:40.349><c> you</c><00:02:40.470><c> have</c><00:02:40.650><c> multiple</c>

00:02:40.750 --> 00:02:40.760 align:start position:0%
because Excel lets you have multiple
 

00:02:40.760 --> 00:02:43.070 align:start position:0%
because Excel lets you have multiple
conditional<00:02:41.760><c> formatting</c><00:02:42.209><c> rules</c><00:02:42.510><c> at</c><00:02:42.720><c> the</c><00:02:42.840><c> same</c>

00:02:43.070 --> 00:02:43.080 align:start position:0%
conditional formatting rules at the same
 

00:02:43.080 --> 00:02:45.080 align:start position:0%
conditional formatting rules at the same
time<00:02:43.379><c> so</c><00:02:44.069><c> you</c><00:02:44.160><c> can</c><00:02:44.310><c> highlight</c><00:02:44.730><c> different</c>

00:02:45.080 --> 00:02:45.090 align:start position:0%
time so you can highlight different
 

00:02:45.090 --> 00:02:47.869 align:start position:0%
time so you can highlight different
things<00:02:45.620><c> to</c><00:02:46.620><c> clear</c><00:02:46.920><c> the</c><00:02:47.069><c> current</c><00:02:47.220><c> formatting</c>

00:02:47.869 --> 00:02:47.879 align:start position:0%
things to clear the current formatting
 

00:02:47.879 --> 00:02:51.380 align:start position:0%
things to clear the current formatting
rules<00:02:48.120><c> just</c><00:02:48.750><c> select</c><00:02:49.049><c> your</c><00:02:49.140><c> cells</c><00:02:50.090><c> then</c><00:02:51.090><c> go</c><00:02:51.329><c> to</c>

00:02:51.380 --> 00:02:51.390 align:start position:0%
rules just select your cells then go to
 

00:02:51.390 --> 00:02:54.050 align:start position:0%
rules just select your cells then go to
conditional<00:02:51.930><c> formatting</c><00:02:52.319><c> and</c><00:02:53.010><c> mouse</c><00:02:53.700><c> over</c>

00:02:54.050 --> 00:02:54.060 align:start position:0%
conditional formatting and mouse over
 

00:02:54.060 --> 00:02:57.140 align:start position:0%
conditional formatting and mouse over
the<00:02:54.180><c> option</c><00:02:54.599><c> that</c><00:02:54.629><c> says</c><00:02:54.780><c> clear</c><00:02:55.680><c> rules</c><00:02:56.040><c> you</c><00:02:57.000><c> can</c>

00:02:57.140 --> 00:02:57.150 align:start position:0%
the option that says clear rules you can
 

00:02:57.150 --> 00:02:58.550 align:start position:0%
the option that says clear rules you can
clear<00:02:57.390><c> the</c><00:02:57.510><c> rules</c><00:02:57.720><c> who</c><00:02:57.989><c> are</c><00:02:58.110><c> just</c><00:02:58.349><c> the</c>

00:02:58.550 --> 00:02:58.560 align:start position:0%
clear the rules who are just the
 

00:02:58.560 --> 00:03:00.949 align:start position:0%
clear the rules who are just the
selected<00:02:59.040><c> cells</c><00:02:59.280><c> or</c><00:03:00.180><c> for</c><00:03:00.599><c> the</c><00:03:00.690><c> entire</c>

00:03:00.949 --> 00:03:00.959 align:start position:0%
selected cells or for the entire
 

00:03:00.959 --> 00:03:04.220 align:start position:0%
selected cells or for the entire
spreadsheet<00:03:01.349><c> in</c><00:03:02.060><c> this</c><00:03:03.060><c> case</c><00:03:03.299><c> though</c><00:03:03.599><c> I'd</c><00:03:03.930><c> like</c>

00:03:04.220 --> 00:03:04.230 align:start position:0%
spreadsheet in this case though I'd like
 

00:03:04.230 --> 00:03:06.619 align:start position:0%
spreadsheet in this case though I'd like
to<00:03:04.440><c> remove</c><00:03:04.739><c> the</c><00:03:05.010><c> greater</c><00:03:05.430><c> than</c><00:03:05.700><c> 4,000</c><00:03:06.450><c> rule</c>

00:03:06.619 --> 00:03:06.629 align:start position:0%
to remove the greater than 4,000 rule
 

00:03:06.629 --> 00:03:08.660 align:start position:0%
to remove the greater than 4,000 rule
while<00:03:07.200><c> keeping</c><00:03:07.530><c> the</c><00:03:07.650><c> rest</c><00:03:07.859><c> of</c><00:03:08.010><c> the</c><00:03:08.099><c> icons</c><00:03:08.489><c> in</c>

00:03:08.660 --> 00:03:08.670 align:start position:0%
while keeping the rest of the icons in
 

00:03:08.670 --> 00:03:11.599 align:start position:0%
while keeping the rest of the icons in
place<00:03:08.989><c> we</c><00:03:09.989><c> can</c><00:03:10.170><c> do</c><00:03:10.290><c> that</c><00:03:10.470><c> by</c><00:03:10.650><c> going</c><00:03:10.950><c> to</c><00:03:11.069><c> manage</c>

00:03:11.599 --> 00:03:11.609 align:start position:0%
place we can do that by going to manage
 

00:03:11.609 --> 00:03:15.589 align:start position:0%
place we can do that by going to manage
rules<00:03:12.030><c> instead</c><00:03:13.670><c> here</c><00:03:14.670><c> you'll</c><00:03:14.910><c> find</c><00:03:15.090><c> a</c><00:03:15.239><c> list</c><00:03:15.269><c> of</c>

00:03:15.589 --> 00:03:15.599 align:start position:0%
rules instead here you'll find a list of
 

00:03:15.599 --> 00:03:17.539 align:start position:0%
rules instead here you'll find a list of
all<00:03:15.900><c> the</c><00:03:16.140><c> rules</c><00:03:16.379><c> that</c><00:03:16.530><c> are</c><00:03:16.680><c> currently</c><00:03:17.129><c> applied</c>

00:03:17.539 --> 00:03:17.549 align:start position:0%
all the rules that are currently applied
 

00:03:17.549 --> 00:03:20.599 align:start position:0%
all the rules that are currently applied
to<00:03:17.730><c> your</c><00:03:17.819><c> cells</c><00:03:18.120><c> to</c><00:03:19.109><c> remove</c><00:03:19.440><c> one</c><00:03:19.739><c> just</c><00:03:20.310><c> select</c>

00:03:20.599 --> 00:03:20.609 align:start position:0%
to your cells to remove one just select
 

00:03:20.609 --> 00:03:23.569 align:start position:0%
to your cells to remove one just select
the<00:03:20.730><c> rule</c><00:03:20.910><c> you</c><00:03:21.060><c> want</c><00:03:21.709><c> then</c><00:03:22.709><c> click</c><00:03:22.739><c> the</c><00:03:23.400><c> wheat</c>

00:03:23.569 --> 00:03:23.579 align:start position:0%
the rule you want then click the wheat
 

00:03:23.579 --> 00:03:25.710 align:start position:0%
the rule you want then click the wheat
rule

00:03:25.710 --> 00:03:25.720 align:start position:0%
rule
 

00:03:25.720 --> 00:03:27.610 align:start position:0%
rule
quick<00:03:25.870><c> okay</c>

00:03:27.610 --> 00:03:27.620 align:start position:0%
quick okay
 

00:03:27.620 --> 00:03:29.960 align:start position:0%
quick okay
conditional<00:03:28.620><c> formatting</c><00:03:29.010><c> is</c><00:03:29.220><c> a</c><00:03:29.250><c> great</c><00:03:29.640><c> tool</c>

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

00:03:29.970 --> 00:03:32.330 align:start position:0%
conditional formatting is a great tool
for<00:03:30.360><c> visualizing</c><00:03:30.510><c> your</c><00:03:31.260><c> worksheet</c><00:03:31.739><c> so</c>

00:03:32.330 --> 00:03:32.340 align:start position:0%
for visualizing your worksheet so
 

00:03:32.340 --> 00:03:33.949 align:start position:0%
for visualizing your worksheet so
practice<00:03:32.760><c> using</c><00:03:33.090><c> some</c><00:03:33.300><c> of</c><00:03:33.330><c> these</c><00:03:33.480><c> rules</c><00:03:33.780><c> on</c>

00:03:33.949 --> 00:03:33.959 align:start position:0%
practice using some of these rules on
 

00:03:33.959 --> 00:03:36.259 align:start position:0%
practice using some of these rules on
your<00:03:34.110><c> own</c><00:03:34.290><c> and</c><00:03:34.620><c> try</c><00:03:35.160><c> combining</c><00:03:35.370><c> them</c><00:03:35.849><c> to</c><00:03:36.030><c> see</c>

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

00:03:36.269 --> 00:03:39.809 align:start position:0%
your own and try combining them to see
what<00:03:36.629><c> they</c><00:03:36.780><c> can</c><00:03:36.840><c> tell</c><00:03:36.959><c> you</c><00:03:37.260><c> about</c><00:03:37.349><c> your</c><00:03:37.530><c> data</c>

00:03:39.809 --> 00:03:39.819 align:start position:0%
what they can tell you about your data
 

00:03:39.819 --> 00:03:41.879 align:start position:0%
what they can tell you about your data
you