Formataci贸 condicional

Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents.

The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the Formatting Bar or the Styles sidebar.

Podeu introduir diverses condicions que consultin els valors de les cel路les o els resultats de les f贸rmules. Les condicions es calculen de la primera a l'煤ltima. Si la condici贸 1 茅s certa segons el contingut actual d'una cel路la, s'hi aplica l'estil de cel路la corresponent. Si no, s'executa la condici贸 2 per a determinar si s'ha d'aplicar l'estil corresponent. Si cap de les condicions concorda amb el contingut de la cel路la, no se'n fa cap canvi en la formataci贸.

Conditional formats do not overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats.


Per a aplicar la formataci贸 condicional, s'ha d'activar l'ordre Calcula autom脿ticament. Trieu Eines 鈻 Continguts de la cel路la 鈻 Calcula autom脿ticament (quan l'ordre estigui activada es mostrar脿 amb una marca de selecci贸 al costat).

Interval de cel路les

Per a accedir a aquesta ordre...

Des de la barra de men煤s:

Trieu Format 鈻 Condicional 鈻 Condici贸.

Des de la interf铆cie en pestanyes:

Trieu Inici 鈻 Condicional 鈻 Condici贸.

Des de les barres d'eines:

Icona Formataci贸 condicional 鈻 Condici贸

Formataci贸 condicional


Defines the range of cells concerned by the conditional formatting. Click on the Shrink button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected.

Llista de condicions

List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want.


Increase priority of the selected condition.


Decrease priority of the selected condition.


Afegeix la condici贸 a la llista de condicions.


Suprimeix la condici贸 de la llista de condicions.

Entrades de la llista de condicions

Specify if conditional formatting is dependent on one of the entry listed on the drop down box.

Condition - Cell value is

Applies a cell style on the cell or cell range controlled by the condition set in the drop down list. The formatting is applied to each cell individually and the condition may depend on other cells values of the selected range.

Condition - Formula is

Applies the selected style to the cell when the formula expression in the text box in the right is not zero.

Condition - Date is

Applies the selected style to the cell when the cell contents is formatted as date and the condition is one of the available date interval in the dropdown list.

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.

Barra de dades

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

Joc d'icones

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

Aplica l'estil

Select the cell style to apply when the condition is verified. Select New Style to open the Cell Style dialog and define the style properties.

Gesti贸 de les condicions

Manage all the conditional formatting defined in the spreadsheet.

Ens cal la vostra ajuda!