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.