Excel Magic Trick 1200


Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods)

DESCRIPTION

See how to use Conditional Format Grades to assign Stop Light Icons to one of three groups: Green Icons, Yellow Icons and Red Icons. See three methods:
1. Problem Setup
2. Conditional Formatting with Icons using built in percentages
3. Conditional Formatting with Icons using assigned numbers as dividing points to split the numbers into three groups.
4. Conditional Formatting with Icons in cells next to grades, which will only show up after a grade in entered. See formula with IF and ISNUMBER functions.
5. Explain Icon Three Set Percentage Algorithm

WORKBOOKS