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

Per a accedir a aquesta ordre...

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

Trieu Format ▸ Condicional ▸ Escala de colors

#### Des de la interfície en pestanyes:

Trieu Inici ▸ Condicional ▸ Escala de colors.

Escala de colors

### Condicions

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.

### Obre un fitxer amb un exemple:

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

Per a accedir a aquesta ordre...

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

Trieu Format ▸ Condicional ▸ Barra de dades

#### Des de la interfície en pestanyes:

Trieu Inici ▸ Condicional ▸ Barra de dades.

### Condicions

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 opcions

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

#### Entry values

Same as the conditions above.

#### Colors de la barra

Trieu el color dels valors positius i negatius.

#### Emplenament

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

#### Eix

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.

• Cap: l'eix vertical no és visible.

#### Longituds de les 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.

## Joc d'icones

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

Per a accedir a aquesta ordre...

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

Trieu Format ▸ Condicional ▸ Joc d'icones

#### Des de la interfície en pestanyes:

Trieu Inici ▸ Condicional ▸ Joc d'icones.

Joc d'icones

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

### Obre un fitxer amb un exemple:

Ens cal la vostra ajuda!