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