Microsoft Excel 2013 - Creating custom icon Sets

This tutorial is presented by Quasar Anytime as part of our Microsoft Office 2013 Training pack. This tutorial will show you how to create a custom icon set.

---

Closed Caption:

do
and I want to shoot video on how to
create your own customized
icon said in conditional formatting in
Excel
in the short video we're going to go
through how to create personalized
icon says so we're going to select an
area within our spreadsheet
which is what we want to apply the
conditional formatting take with then
going to go into conditional formatting
and icon set we're going to miss
or the preset option and go to mall
rules
and then within the rules section I'm
going to go through and actually specify
my own specific icons each my your
child's
some going to use the first option
a green output Sarah these things are
going well and on the up
Ambala I'm going to use an amber
exclamation mark
for the Red I'm going to use a warning
Red Cross
so I'm going to go for the red cross
symbol their I have actually chosen
three completely different
icon from three different options and I
can then go through and set the values
so I'm quite happy for this to look at
67 percent in about for the green up RI
the warning exclamation mark will be
between 67 and Bessie 3
and the Red Cross will be for anything
below a 33 percent
and then going to click the OK button
and those symbols and now displayed on
screen
so I have actually created my own past
lies custom icon set
rather than having a preset one from
Excel