Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 377
Onlyjob Avatar asked Sep 19 '14 03:09

Onlyjob


1 Answers

  • 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.
like image 65
Axel Richter Avatar answered Sep 19 '22 18:09

Axel Richter