Search code examples
libreoffice-calc

LibreOffice Calc: how to highlight row as per cell value?


In the spreadsheet I want to automatically highlight row once a particular cell value is entered.

I've configured H column with list values: [valid,invalid] in DataValidity. The idea is to apply custom hlt-invalid-bg style to row where "invalid" value is set in the cell H.
I'd like to learn how it can be done using FormatConditional Formatting or using any other method.


Solution

    • Select the whole rows, the conditional format shall apply to.
    • Select Format - Conditional Formatting- Condition
    • The Dialog "Conditional Formatting for A1:AMJ[n]" is shown. On bottom in Range: A1:AMJ[n] is shown.
    • In Condition 1 select "Formula is" and input the Formula

      ($H1="invalid")

    • In Apply Style select "New Style...". The Dialog "Cell Style" is shown.

    • In Background tab select a background color.
    • Click OK in all Dialogs.