Ask Your Question

[SOLVED] [Calc] Conditional formatting: highlight lowest value in a row

asked 2016-07-15 15:54:46 +0200

theMoose gravatar image

updated 2017-01-05 13:47:35 +0200

Hello everyone,

I'm fairly new to LibreOffice Calc as it comes to 'advanced' function and now I'm running into a problem as it does not do what it is suppost to do...

I'm trying to do some conditional formatting on a range of cells in one row (B19-K19). I want to highlight the cell with the lowest value (green background and Bold text), in my case cell D19

What I do is to add a conditional formatting to the range B19-K19, select 'Cell Value', 'Is equal to' and than add the formula MIN(B19:K19) as the 'value'. And than I select the correct format to use (called 'MinValue'). I'm using a Dutch version, so forgive me if my translations are not the same as in the software.

What I get is that not only cell D19 changes to this 'MinValue', but also the cells H19, I19 and K19, which all have higher and other values...

What am I missing or doing wrong here? All help and suggestions are welcome. Thanks in advance.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-07-15 16:41:47 +0200

Lupp gravatar image

You used relative addressing in MIN(B19:K19). Whils this expression is correct viewed from the first (topmost leftmost) cell B19 of your CF range, it will be evaluated as MIN(C19:L19) when applied for cell C19 to decide if the 'MinValue' format should be overlaid.
You will often need relative addressing in CF. However, in your case the formula should read MIN($B19:$K19) which is giving an absolute range with respect to the columns. Copied down to row 20 it will nonetheless correctlöy adapt, because the row part is still relative.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-15 15:54:46 +0200

Seen: 3,325 times

Last updated: Jan 05 '17