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

Please purchase the course before starting the lesson.

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.

add-risk-robots-milestone-up-and-down-icons-to-excel-cells

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

add-risk-robots-milestone-up-and-down-icons-to-excel-cells

To see the full course contents click here.

Back to: Intermediate Excel Course > Conditional Formatting