Stel uw vraag

jarfil's profiel - activiteit

2020-08-16 21:41:06 +0100 badge ontvangen  Weten (bron)
2019-12-12 11:20:31 +0100 badge ontvangen  Goed Antwoord (bron)
2019-11-21 13:22:05 +0100 badge ontvangen  Supporter (bron)
2018-04-10 15:54:18 +0100 badge ontvangen  Mooi Antwoord (bron)
2017-08-11 13:23:23 +0100 badge ontvangen  Tovenaar (bron)
2017-08-11 13:23:23 +0100 badge ontvangen  Leraar (bron)
2016-02-04 11:05:26 +0100 badge ontvangen  Beroemde vraag (bron)
2015-03-07 18:43:24 +0100 badge ontvangen  Opvallende Vraag (bron)
2015-03-04 22:00:48 +0100 badge ontvangen  Populaire Vraag (bron)
2015-03-04 05:53:46 +0100 beantwoorde een vraag Calc howto: conditional format a row based upon a column

You can do this with a "Formula is" condition in conditional formatting.

  1. Select all the cells you want the formatting to be applied to, for example B1:E3000
  2. Format -> Conditional Formatting -> Condition
  3. Change condition type to "Formula is"
  4. In the field next to it, type in a formula that will set the style if true. For example: $A1=6008
    This will make all the cells in each row to check the value of the cell in column A of that row.
  5. Select your desired style, and press OK

Repeat for as many styles and specific values as you need.

To copy the conditional formatting to another file:

  1. Create an empty sheet and set the conditional formatting (or duplicate a sheet with the formatting and remove all data)
  2. Open both files at the same time
  3. Copy the empty sheet (with the conditional formatting) from the first file to the second file
  4. Copy all the data you want formatted onto the new sheet
  5. If you need to fix cell ranges for the conditional formatting, go to Format -> Conditional Formatting -> Manage, click Edit, and edit the Range value.
2015-03-04 05:26:54 +0100 badge ontvangen  Redacteur (bron)
2015-03-04 05:26:24 +0100 stelde een vraag Conditional format cell borders based on adjacent cells

In LibreOffice Calc (, Windows), I can use Conditional Formatting to set the background of cells depending on their content:

Conditional formatting background of cells

However, I can't seem to find a way to conditionally set borders based on adjacent cell values being equal or not to each cell's content.

What I would like is to get a result like the following, without having to set the borders by hand:

Desired conditional formatting result