Color Markers application of Optipe Data Tools Suite adds color marks according to numerical data ranges for better visualization of the data.

Use this application to:

• Mark in red or blue evaluations of students in a course.
• Rank in red, yellow or green your sales or production.
• Paint or fill the cells with a color depending on its value.
• This application was initially created for Excel 2003, where conditional formats were complex to administer.

Features:

• The markers are added in a new column adjacent to the column in which the data are in the form of a LED or light. Alternatively, you can fill the cells where the data is located in the same colors.
• 2 to 5 categories are allowed, each with its own color.
  • 2 states: red and blue
  • 3 states: red, yellow and green
  • 4 states: red, yellow, green and blue
  • 5 states: red, orange, yellow, green and blue
• You define the range of values ​​for category.
• You can change the color order (ascending or descending).

Examples: