Microsoft Excel Conditional Formatting 2 of 3: Data Bars and Icon Sets - Wise Owl

http://www.wiseowl.co.uk - Learn how to apply conditional formats in Microsoft Excel to grade a range of numbers using data bars and icon sets.

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Visual Studio, ASP.NET, VB.NET, C# and more!

---

Closed Caption:

welcome to this wise I'll tutorial
if you watched the last part in this
video series
you might remember that we applied some
conditional formats
to use some film Oscar nominations
parties
at the situation where if if the film
was nominated for two
of you Aussies it received purple
background
it was nominated for between three and
10 Oscars
he had a yellow background and any more
than 10
nominations it had greenback we're gonna
look at a couple of other styles
conditional formatting in this part to
the series and the first one is gonna be
easing
data bomb that if data bars that it
applies at
different with all linked bar she sells
with different values in them I'm going
to use this to you show
the film to rations in minutes
with different size bass start with I
need to select
all the films duration: bodies I think
cell
hefty hold on control and shift and tap
the down arrow key
said the mall I can then go to the
conditional formatting tool
and this time I'm going to look at the
data docs option
now in the firemen you really got a
choice of beef
is what cholera are you don't use and if
you're not sure you can try helping your
mouse over the different options
the sea life preview on the left son go
this
top left hand corner the pale blue t
wanna cry I'll time
not and immediately I guess my day to
pass apply to the cells
and the idea behind behind this is that
the larger the number in the cell
the big at the bar small number the
short at the top
simple by Coley was dynamically as well
as I changed with
a column with the past changes
proportion
take that back a little bit on slightly
disappointing thing
is thats the with at the bar well at
least with the shortest par
is determined by Accel shortest film
analyst is men in black
City unfortunately that didn't last any
longer than 80
minutes but Excel still shows up with
the data by which feels at least half
the cell
almost half the cell smoking to make
some modifications
tell Excel use aside different value for
the shortest par
to do that and he disliked any sell the
house the data by reply to it
at national for munching and choose
manage rules I can find my day to buy
rice molest
click on it and then she said it will I
get quite a lot of options available
here
on sinister my soft money fine T which
is the minimum value for the with
a bar and the maximum sensitive in
automatic for the minimum saw like
going to click on this drop-down arrow
and tell XLT is the lowest value
from the range of cells I have selected
Sami Salo is bob with
the minimum shortage power P with these
values 88 minutes
likewise for the maximum I'm gonna tell
XLT
the highest value in the range cells a
change
formatting properties here but I quite
like the hell to the one that I select
Italia
Sun disk and click OK when I click OK
again to keep a quick I am what happens
the value d80 about that and i'm Jack
tonight just picking up that the value
88
is the smallest number in the range and
the shortest par supplied
sect values 88 asked baseball it's like
one more example we're going to look at
is to do with something called I
concepts
and on training courses appear in this
is always everybody's favorite style of
conditional format
it was quite excited at this point so I
concepts were going to play I concept to
our
budgets column I'd like an example
wet the the smaller the amount of money
I spend the night film
to make it I get green traffic light
films why spend a lot of money
make it I get a red traffic light and
anything in the middle
I can arrange light so again the
starting point is to select
love the cells I want formats console GT
control shift down alright want
not I can go to the conditional
formatting to and find the set
and formatting option I'm interested in
just mention on skipping color scales in
this tutorial I think that
a bit too gordy for my tastes that is
that they apply different
color range hop cold color strips and
the scale of numbers
we can avoid damaging agents tracked
item sets an area as exciting options
I'm gonna find the had much additional
one I was careful which is the three
traffic
ice green am a rat and simply click on
it and
as in most things that conditional
formatting Excel the tenants for itself
which sells you get a red traffic light
which ones getting orange
which ones get a green and really
irritates me it applies it in completely
the wrong order
the exam plunged again for is the cells
the chip which case the vet
traffic lights and was a high budget
which has the green
something to modify that and change the
order of my traffic lights
did not i click into the cell with the
format apply to it
had to the conditional formatting to and
choose manage rules again
speaking used to this by now the option
I want to modify the icon set
room click edit room and
how convenient is a nice little button
and i cant the controversy the order
my icons and I click on it scream of
with rat
again that's right screen
I could also if I wants to change the
way Excel applies
yeah politicized to apply T traffic
lights
by default it is by percentages I could
modify this
pick a specific number that's that have
two red light
a specific number that the orange light
and so on and so on and so on
friendly their sizes I quite like the
other sandy style this example
so when I click OK and cocaine one more
time
should find now I have the symbols I
want
there again Nana at each day to pass and
icon sets
in conditional formats for Excel