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

From the menu bar:

Escolla Formato - Condicional - Escala de cores

From the tabbed interface:

Choose Home - Conditional - Color Scale.

From toolbars:

Icona Escala de cores

Escala de cores


Conditions

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

Abrir ficheiro cun exemplo:

Data Bar

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

Para acceder a esta orde...

From the menu bar:

Escolla Formato - Condicional - Barra de datos

From the tabbed interface:

Choose Home - Conditional - Data Bar.

From toolbars:

Icona Barra de datos

Barra de datos


Conditions

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

More Options

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

Entry values

Same as the conditions above.

Bar Colors

Choose the color for positive and negative values.

Fill

Axis

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

Bar Lengths

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.

Abrir ficheiro cun exemplo:

Icon Set

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

Para acceder a esta orde...

From the menu bar:

Escolla Formato - Condicional - Conxunto de iconas

From the tabbed interface:

Choose Home - Conditional - Icon Set.

From toolbars:

Icona Conxunto de iconas

Conxunto de iconas


Available Icon Sets

Conditions for thresholds

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

Abrir ficheiro cun exemplo:

Precisamos da súa axuda!