B14.jpg
Professional Applications for Microsoft Excel
EnglishEspañol (spanish formal Internacional)PortuguêsDeutsch

Optipe Data Tools Suite - Color Markers

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

Data Tools Suite Color Markers

Color MarkersUse 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).
See also:
BuyNow

Examples:

Video Example. Add color markers in a new column.

 

Video Example. Add color markers in the same column.

Copyright © OPTIPE - Optimize Time Performance. Professional Applications for Microsoft Excel 2017

Template by Joomla Themes & Copywriter.