# 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.)

http://imgur.com/L6RwDVf

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

edit retag close merge delete

Sort by » oldest newest most voted

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.

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.

( 2016-11-02 13:55:16 +0200 )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.

( 2016-11-02 23:30:25 +0200 )edit