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 accedir a esta orde...

From the menu bar:

Choose Format - Conditional - Color Scale

From the tabbed interface:

Choose Home - Conditional - Color Scale.

From toolbars:

Icon Color Scale

Escala de colors


Condicions

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

Obri un fitxer amb un exemple:

Barra de dades

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

Per accedir a esta orde...

From the menu bar:

Choose Format - Conditional - Data Bar

From the tabbed interface:

Choose Home - Conditional - Data Bar.

From toolbars:

Icona Barra de dades

Barra de dades


Condicions

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

Més opcions

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

Entry values

Same as the conditions above.

Bar Colors

Trieu el color dels valors positius i negatius.

Emplenament

Eix

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

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.

Obri un fitxer amb un exemple:

Joc d'icones

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

Per accedir a esta orde...

From the menu bar:

Choose Format - Conditional - Icon Set

From the tabbed interface:

Choose Home - Conditional - Icon Set.

From toolbars:

Icona Joc d'icones

Joc d'icones


Jocs d'icones disponibles

Conditions for thresholds

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

Obri un fitxer amb un exemple:

Ens cal la vostra ajuda!