• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 55
  • Last Modified:

How does this excel color coding work

This is the file:

This is a screenshot:

This is a screenshot of the first tab/sheet:

I would like to know how the color coding works here. I would like to use it in another file and also maybe edit the color coding in this file.

How were the circles created and inserted? How to setup the conditions for the colors? How to make it change?

There is a box at the top left called "Thresholds" and the circles themselves are used right from column N onwards. These are the two relevant spots on the sheet I guess.
1 Solution
Richard DanekeTrainerCommented:
The spreadsheet is using Conditional Formatting for the cells and the circles are called Icon Sets.  

Once the Icon Sets are placed in a cell, the Conditional Formatting, Manage Rules... provides options for setting the thresholds for circles to change colors.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now