How to Apply Icon Sets in Excel : Tips for Microsoft Office & Windows

Subscribe Now:
http://www.youtube.com/subscription_c...

Watch More:
http://www.youtube.com/ehowtech

Applying icon sets in Excel is something that you can do right from the main ribbon toolbar. Apply icon sets in Excel with help from a certified career, small business and life coach in this free video clip.

Expert: Crystal Williamson
Filmmaker: Nick Laden

Series Description: Microsoft Office is one of the most widely-used productivity suites for both the Mac OS X and Windows platforms. Get tips on Microsoft Office and Windows with help from a certified career, small business and life coach in this free video series.

---

Closed Caption:

them
hey again this is crystal we're applying
icon sets that are in Microsoft Excel
great great new feature in Excel 2010
you can get a visual cue a what's
perhaps
under or over a certain demarcation that
you have a certain amount that you had
in your Excel file so here I am an Excel
and I want to see will what numbers are
perhaps
over 100 are over 200 I select
all all the amounts that are in this
Excel trial and then in the Home tab I
go to conditional formatting
and hear the options that are in here
here's icon set
and your I can use any of these
directional shades indicators anyone
that I want
and as soon as I homer over it I'll get
a little preview what they look like
these little traffic lights are really
great
so I can just click on them and I'll see
where their under or over a certain
amount so notice summer green
red and yellow up well I want to
actually distinguish the amounts in
there
so I'm going to go to icon set single
more rules
and writing here this is where I can say
for the icon set on the icon style
when the value is greater than or
equal to a particular number notice it
says percent here
I can change that and number and then I
can make it as opposed to that value I
said
you know what I wanna make anything
that's 75 and over
anything that's
under this number anything that's under
sixty soon as I click OK
here go my icon set so notice
quite a bit is over 70 quite a bit is
sixty
and under nice right that's how you ply
icon set
in Microsoft Excel great new feature
this is crystal
Theissen them