Conditional formatting not working correctly

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.

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.

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.

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.