0 of 135 lessons complete (0%)
Conditional Formatting

Add risk robots, milestone, up and down icons to Excel cells

You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.

Another feature of Conditional Formatting is the ability to add icons to your cells. The most common ones are available e.g. risk traffic lights, rating icons, up/ down arrows and more.

This lesson shows you how to easily add icons to your cells and how useful they are in helping your audience understand your reports.

As shown below we can use mini pie charts to show how complete a project is.


Following the same process you can add traffic lights to the risk rating column


To see the full course contents click here.