From The Document Foundation Wiki
Jump to navigation Jump to search

We will use the possibility of defining the format as a function of the result of a formula.

  1. Create as many styles as you require for the formats. In our example, we will create four cell styles, in which the only difference is the color of the background, according to the name of the style : green, yellow, orange and red. We want to conserve the Default style for the cells that do not have a whole value between 1 and 4. The result expected :
    copie d'écran plage contenant de 0 à 4 formatée
    Résultat du formatage conditionnel