# 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.

P'aportar a esta orde...

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

Escueyi Formatu - Condicionáu - Escala de color

#### Dende la interfaz con llingüetes:

Escueyi Aniciu - Condicionáu - Escala de color.

#### Dende les barres de ferramientes:

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.

P'aportar a esta orde...

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

Escueyi Formatu - Condicionáu - Barra de datos

#### Dende la interfaz con llingüetes:

Escueyi Aniciu - Condicionáu - Barra de datos.

Barra de datos

### Condiciones

The calculation of the bar area fill is based on the conditions below:

• 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.

#### Colores de la barra

Esbilla'l color de los valores positivos y negativos.

#### Fill

• 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.

#### Exa

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.

• Dengún: la exa vertical nun ye visible.

#### Llonxitúes de barres

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.

## Xuegu d'iconos

Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available.

P'aportar a esta orde...

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

Escueyi Formatu - Condicionáu - Xuegu d'iconos

#### Dende la interfaz con llingüetes:

Escueyi Aniciu - Condicionáu - Xuegu d'iconos.

Xuegu d'iconos

### Xuegos d'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.