English

Creación & Evaluación de Modelos

Herramientas de Análisis de Modelos

Bases de Datos Excel

Modelos Financieros

Funciones en línea

Herramientas de Presentación

Otros

Paquetes

Art of Conditional Formatting for Excel

Conditional Formatting for Microsoft® Excel® 1.3.0

Analice rápida y fácilmente la información de sus hojas de cálculo en Excel usando “n” niveles de formato condicional disponibles en esta poderosa herramienta.

Incluye!

  • Un año de soporte
  • Recursos Gratis
  • Si usted adquiere Conditional Formatting for Excel puede actualizarlo a Excel Model Builder pagando solo la diferencia.
View Demo
Resources

Conditional Formatting for Excel

Precio: €24.63

Demo

Comprar
Revise el inmenso set de herramientas disponibles en Conditional Formatting for Excel
(Disponible solo en Ingles)
   

    Advanced Tools

 

Formatting with "n" conditional formatting levelsFormatting with "n" conditional formatting levels

Multiple conditional analysis & formatting is the tool suitable to format cells in a database.

Cell's math by formatCell's math by format

Use this gainful tool to search all cells in a specific range with a particular background color and to do some math with the results.

Searching easily Searching easily

This is a useful tool that has been designed to make searching in a data range both simple and efficient.

...By format...By format

1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

...By logic criteria...By logic criteria

1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

...By text...By text

1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

Cell's math with selected cellsCell's math with selected cells

You may want to do some math only with selected cells in the active worksheet

Conditional TextConditional Text

Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.

Conditional Text in activesheetConditional Text in activesheet

It is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.

Conditional Text in selectionConditional Text in selection

Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.

Sumif & CountifSumif & Countif

This useful tool allows you to sum and count data regarding to conditions specified in a criteria table.

SumifSumif

In order to understand the SUMIF option functionality, Think about the following situation...

CountifCountif

In this case, we have a table with the names and the score of each one of them, also a criteria table.

Saving modelsSaving models

You often happen to run the same models once and again, so the process of filling in the same information becomes repetitive.

Specifying cellsSpecifying cells

This tool selects cells of a given range, but only taking into account those with a given format.

Exporting sheets as...Exporting sheets as...

Do you only wish to export any sheets of your workbook? Use the "Export sheets as..." tool, and simplify this task.

Managing SheetsManaging Sheets

Use Sheet Manager –a comprehensive tool that will make any worksheet management task easier to you.

Managing WorkbooksManaging Workbooks

Managing your open workbooks is made easy with the Workbook manager tool.

Freeze | dividing panesFreeze | dividing panes

We sometimes work with models whose information does not fit in the screen.

Toggle settingsToggle settings

We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook, we will have to do it one at a time.