Ask Your Question

Conditional formatting nightmare- Resolved

asked 2018-08-15 23:54:37 +0100

Fan gravatar image

updated 2018-08-16 21:57:39 +0100

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.C:\fakepath\issue libre office.jpg

Thank you!


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-08-16 10:32:17 +0100

kompilainenn gravatar image

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.

edit flag offensive delete link more


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?


Fan gravatar imageFan ( 2018-08-16 15:47:47 +0100 )edit
  1. Mark your question as resolved

  2. Create new question and attach there file-example. I didn't understand you

kompilainenn gravatar imagekompilainenn ( 2018-08-16 20:31:27 +0100 )edit

answered 2018-08-16 06:44:07 +0100

gtomorrow gravatar image

You need to add a condition. Condition 1: Cell value is equal to 0. Format it as Default.

Nightmare over! :)

edit flag offensive delete link more


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?

Fan gravatar imageFan ( 2018-08-16 14:29:39 +0100 )edit

Use Equal to - "" condition as @kompilainenn suggested. This will apply Default format when cell is not populated.

SM_Riga gravatar imageSM_Riga ( 2018-08-16 15:20:04 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-15 23:54:37 +0100

Seen: 114 times

Last updated: Aug 16 '18