Axuda do LibreOffice 7.6
Empregue Formato condicional para definir condicionadas baseadas nun intervalo que determinen o estilo de cela que se lle aplique a cada cela dun intervalo dado segundo o seu contido. . Aplícase o estilo de cela que corresponda coa primeira condición avaliada como verdadeira. Os estilos de cela aplicados por medio do formato condicional substitúen os estilos de cela aplicados manualmente mediante a Barra de formato ou o panel Estilos da barra lateral.
You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format.
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.
To apply conditional formatting, AutoCalculate must be enabled. Choose Data - Calculate - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled).
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.
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.
Adds the condition to the condition list.
Deletes the condition from the condition list.
Specify if conditional formatting is dependent on one of the entry listed on the drop down box.
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.