Excel Icon Sets Conditional Formatting Reports

Conditional Formatting with Icon Sets

---

Closed Caption:

this video game-like at creating icon
sets
in Excel our first begin by selecting
a group its data like to compare against
each other
on their home to have a the conditional
formatting command
I have the icon sets
commands so what's happening here is a
hug a rover
these options here all the break in the
data down into
either group's 3 4
if I choose an icon set with 4 even time
justice with her icon set asides I want
to do is break down
in group 3 such start off with
a 3 Ste three circle shapes here
now among our first look here we see
that the higher numbers are green
near Boulder damper
and Santa Fe here agree but let's say I
wanted to do a
control the setting so that
green arm is going to be
200 or higher in a yellow circle
will put me in the range between say
fifty
and 199 then read
is gonna be less thing 50
basically 49 our or lower their
okay so I can change settings
with conditional formats like the cells
good conditional formatting is
manage rules from here I have the
ability to
changed the settings by clicking on
editor rule will take me into the
settings here so my current look here's
which got 67 percent
33 percent are markings here trick
just go into the number setting here
will say
that when the values greater than or
equal to you 200
Mike to have a green circle I'll change
my next one
to a number of put that 50 okay
and not only the hacked house had the
ability to you
customizing Excel 2010 for 2013 you do
have the ability to change
the settings 2007 Excel you can
create your own scenarios here but you
can't
blend them together so I like to have a
red flag
if we're less than 50 so
there we go we had okay inner
okay and Tom
get a different scenario here looking at
dat now
om let's test it out here so that snake
Colorado Springs
dropped to forty nine a red flag let's
make Colorado Springs jump to
2005 she turned green streak alright
you have the ability to also create a
legend
as well so when I'm gonna do is just
delete the cells here
and type a quick number you're at Misys
in a moment here suggests
realize that these numbers I'm typing
this kinky I use the format painter
here after I clicked isolated since
commercial for he's a
format pair to copy over the cells said
Act
gave me the conditional formatting also
gave me the borders which I can remove
I don't want those all but basically
we're gonna take days
out other numbers by going to cancel for
mandrels there's one saying I share with
you
it's the show icon only this will allow
us to have the same settings to set you
have to see those numbers I just put in
there
no can here we are
and I've got the ability now to you I
should other
eso pretty cool stuff there at the
ability to you
manage legend and have the data settings
similar to that thanks for watching hope
you enjoyed