hello!
I have been pulling my hair out at an issue for about 2 hours. I am trying to use conditional formatting with three different conditions. red if the value of the cell is equal or less than 4, orange if between 5 and 8, and green if equal or greater than 9. That seems to have worked, however all the cells that aren’t populated yet ended up red too…
How do I ensure that blank cells keep the white background until populated?
I have attached a picture.issue libre office.jpg
Thank you!
Fan
You need to add a condition. Condition 1: Cell value is equal to 0. Format it as Default.
Nightmare over! 
thank you, it did work to get rid of the red in blank cases, but “0” is a possible number that will populate the cells, and it should be red when entered. How do I achive red cells for 0 but white for blanks?
Use Equal to - “” condition as @kompilainenn suggested. This will apply Default format when cell is not populated.
You need to add a condition and make it first in list.
Condition 1: Cell value is - equal to - “”. Set up style for it as Default.
thanks, it worked!!!
If it’s not too much to ask. Is there a way to achieve this:
say in cell K3 I have a class average for a whole half-term of tests
in cells K5 to K30 I have the students’ average.
Is there a way to change the colour of the cell according to the student’s result in relation to the class average?
As in below ==> red
equal ==> orange
above ==> green
Knowing that each cell is already filled with a formula?
Thanks!
Mark your question as resolved
Create new question and attach there file-example. I didn’t understand you
