Sep 22 2022 05:44 AM
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 | |||||||||||||||||||||||||||||||
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 |
Sep 22 2022 05:58 AM
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.
Sep 22 2022 06:09 AM
@Hans Vogelaar Thank you. I managed to figure something out. Appreciate you taking the time to reply.