# Condition - All cells

Applies the conditional formatting to the set of cells defined in the selected range. The formatting is applied based on the contents of the whole range.

## Color Scale

Applies a color scale to a range consisting of displaying a bicolor or tricolor gradient on this range depending on the value of each cell.

Para acceder a esta orden…

#### Desde la barra de menús:

Vaya a Formato ▸ Condicional ▸ Escala de colores

#### Desde la interfaz en pestañas:

Vaya a Inicio ▸ Condicional ▸ Escala de colores.

#### Desde las barras de herramientas:

Escala de colores

### Condiciones

The calculation of the color scale depends on 2 or 3 conditions, defined as follows:

• Min (Max): calculates using the minimum (maximum) values in the range.

• Value: a fixed value. Enter the value in the text box.

• Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.

• Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.

• Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.

## Barra de datos

Data bar option fills the cell with solid or gradient color corresponding to the numeric value in the cell.

Para acceder a esta orden…

#### Desde la barra de menús:

Vaya a Formato ▸ Condicional ▸ Barra de datos

#### Desde la interfaz en pestañas:

Vaya a Inicio ▸ Condicional ▸ Barra de datos.

Barra de datos

### Condiciones

El cálculo del relleno del área de la barra depende de las condiciones enumeradas a continuación:

• Automatic: calculates using the minimum and maximum values in the range.

• Min (Max): calculates using the minimum (maximum) values in the range.

• Value: a fixed value. Enter the value in the text box.

• Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.

• Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.

• Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.

### Más opciones

The Data Bar dialog opens to add details on the display of data bars.

#### Entry values

Same as the conditions above.

#### Bar Colors

Elija el color de los valores positivos y negativos.

#### Relleno

• Gradient: set a color scale between the color of positive (negative) values and white.

• Color: use the positive (negative) color for the entire data bar, no fade out gradient.

#### Eje

Set the position of the vertical axis for the data bar. Values are

• Automatic: position the vertical axis in the middle of the maximum and minimum values.

• Middle: set the vertical axis in the middle of the column.

• Ninguno: el eje vertical no es visible.

#### Longitudes de barras

Sets the minimum (maximum) length of the data bars, as a percentage of the column width.

#### Display bars only

Do not display values in the cell, only the data bars.

## Conjunto de iconos

Añada un icono a la celda en función del valor y umbrales especificados. Hay varios conjuntos de iconos a su disposición.

Para acceder a esta orden…

#### Desde la barra de menús:

Choose Format - Conditional - Icon Set

#### Desde la interfaz en pestañas:

Choose Home - Conditional - Icon Set.

#### Desde las barras de herramientas:

Conjunto de iconos

### Conjuntos de iconos disponibles

• 3, 4 or 5 - arrows

• 3, 4 or 5 - gray arrows

• 3 - flags

• 3 - traffic lights 1 and 2 (two different designs)

• 3 - Smileys 1 and 2

• 3 - symbols

• 4 - circles from red to black

• 4 or 5 - ratings

• 5 - quarters

• 5 - boxes

### Conditions for thresholds

Conditions to set the thresholds for each icon can be specified as follows

• Value: a fixed value. Enter the value in the text box.

• Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.

• Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.

• Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.

### Abrir un archivo con un ejemplo:

¡Necesitamos su ayuda!