Help with conditional formatting

Question

Hi Community,&nbsp;&nbsp;I'm hoping someone can help me with a problem i'm encountering whilst setting up some conditional formatting on the table below.&nbsp;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 ?&nbsp;&nbsp;Struggling to thing about how i would apply this. Would appreciate someone's wisdom !.&nbsp;&nbsp;&nbsp;DateMonth12345678910111213141516171819202122232425262728293031April&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;June&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;July&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;August&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

Mr_Raj_C&nbsp;
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.
&nbsp;

mr_raj_c · Answer

HansVogelaar&nbsp;Thank you. I managed to figure something out. Appreciate you taking the time to reply.

Forum Discussion

Help with conditional formatting

2 Replies

Resources

	Date
Month	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
April
May
June
July
August