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

Question

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 Data→Validity. 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 Format→Conditional Formatting or using any other method.

Answer 1

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