HELLO,
I have the expression below on a line chart background to change the colors.
if(match(CODE, '24','70'), RED(), BLUE())
This is working BUT I am getting a BLUE color on days where they were 24 and 70 on the same date.
I need the expression to give me red even if it finds 24 and 70 on the same date. So 27-Jun-12 and 30-Jan-15 should also be highlighted RED().
It is currently coloring those codes Blue. I appreciate your assistance.
Thanks
| CODE | DATE |
| 24 | 18-May-12 |
| 50 | 25-Jun-12 |
| 24 | 27-Jun-12 |
| 70 | 27-Jun-12 |
| 15 | 20-Nov-12 |
| 24 | 30-Jan-15 |
| 70 | 30-Jan-15 |
| 78 | 3-Feb-15 |
| 100 | 15-Mar-15 |
| 70 | 28-Mar-15 |
Message was edited by: Didier Agonvonon
