Excel Magic Trick 1200

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


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


Be the first to comment

Leave a Reply