Help with conditional formatting

Occasional 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 !.

 

 

 Date
Month12345678910111213141516171819202122232425262728293031
April          
May                               
June                               
July                               
August                               
2 Replies

@Mr_Raj_C 

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

S1768.png

S1769.png

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.