Ask Your Question

Conditional formatting not working correctly

asked 2016-07-12 08:13:25 +0100

mikerobinson gravatar image

updated 2016-07-12 08:14:50 +0100

I am trying to compare the features and prices of some scales I found on Amazon to be used in a nutritional consultation office. For each feature I add either a Y or an N if it's present or not in that particular item. What I want to do is format the cell with a red or green BG based on this value.

This is how I did that:

  • I added a red BG and green BG to empty cells
  • In the "Styles and formatting" dialog (F11) I added 2 new styles from selecting those cells individually.
  • I selected the range B4:I18 and went to Format > Conditional formatting > Condition and added a condition "If cell value is equal to 'Y' apply style 'Yes_result'" and similarly for 'N'.

However for some reason it turns out like this:

(ok seriously, 3 points needed to add an image to a question. that's rather ridiculous.)

I was going to attach the file here so you could see for yourselves, but well.. Need some pointies.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-07-12 10:13:18 +0100

m.a.riosv gravatar image

What you are doing it's use the value of the cell where you are not the cell in the column with the Y/N, and it's mandatory double quotes for the text "Y" or "N".

It's important to play properly for copying the conditional format, the use of relative/absolute references in the formulas for the conditions.

image description

edit flag offensive delete link more


For some reason I was never notified of your reply. Thank you for your answer. I am a bit confused as to why this is happening. I don't understand what you mean by "it's use the value of the cell where you are not the cell in the column with the Y/N". I'm just going to report this as a bug with LibreOffice because it is not working as expected, and if this is the desired behavior then it's a UI bug. Either way it's a bug.

mikerobinson gravatar imagemikerobinson ( 2016-11-02 13:55:16 +0100 )edit

Maybe you think it's a bug but I think not with no other way to make it works properly. How to use absolute/relative references it the basic here.

m.a.riosv gravatar imagem.a.riosv ( 2016-11-02 23:30:25 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-12 08:13:25 +0100

Seen: 916 times

Last updated: Jul 12 '16