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

libreoffice-calc
Onlyjob picture Onlyjob · Sep 19, 2014 · Viewed 8.9k times · Source

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

Axel Richter picture Axel Richter · Sep 19, 2014
  • 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.

Related questions

Does LibreOffice Calc support JSON file importing/sorting?

I've been trying to import a couple of .json files into LibreOffice Calc. Although I can get the raw data in, it isn't sorting as I would think it might (by placing different pieces of info into each cell). Does …

Read More
Applying row based filter instead of column based in LibreOffice or other SpreadSheet tool

We all know the standard filter, where you pick which rows to show depending on values in a particular column (or columns). Is it at all possible to the the same, but picking which columns should be visible depending on …

Read More
How to refer to a cell when the address is in a variable

For example, in an expression, instead of writing the address A1, how can I write something like: A(B1) with B1 = 1.

Read More