Help with conditional formatting

Brass Contributor

Hi Community, 


I'm hoping someone can help me with a problem i'm encountering whilst setting up some conditional formatting on the table below.


So essentially i want to apply 3 conditions in the table below. If a value is greater than x, shade the cell red. If the value is equal to or less than x, shade it green. However, when i apply these conditions, it makes the whole table green (assuming because the value is "0" or "blank". So i'm assuming i also need to add something which would only apply these conditions if the cell has data ? 


Struggling to thing about how i would apply this. Would appreciate someone's wisdom !.



2 Replies


One option is to create a third rule, with Cell Value, equal to, ="" and fill set to No Color.



Another option would be to change the rule for less than x to a rule of type 'Use a formula to determine which cells to format', but that would be more complicated.


@Hans Vogelaar Thank you. I managed to figure something out. Appreciate you taking the time to reply.