Hi all,
If we use the example below, if we take every Cake in P1, they both have the same date. The only time it doesn't work, it's with Pie in P4, so I would need this cell to be highlighted (both can be highlighted, not just one). I only compare product with the same product (so Cake with Cake and not with Pie) and the same period. Those who doesn't match must be highlighted.
Is it possible?
Thanks in advance.
If we use the example below, if we take every Cake in P1, they both have the same date. The only time it doesn't work, it's with Pie in P4, so I would need this cell to be highlighted (both can be highlighted, not just one). I only compare product with the same product (so Cake with Cake and not with Pie) and the same period. Those who doesn't match must be highlighted.
Is it possible?
Thanks in advance.
Product | Period | Date |
Cake | P1 | 2020-01-01 |
Cake | P1 | 2020-01-01 |
Cake | P2 | 2020-02-01 |
Cake | P3 | 2020-03-01 |
Cake | P4 | 2020-04-01 |
Pie | P3 | 2020-03-01 |
Pie | P4 | 2020-03-01 |
Pie | P4 | 2020-04-01 |
Donut | P1 | 2020-01-01 |
Donut | P2 | 2020-02-01 |
Donut | P2 | 2020-02-01 |
Donut | P3 | 2020-03-01 |
Donut | P3 | 2020-03-01 |
Donut | P4 | 2020-04-01 |
Donut | P5 | 2020-05-01 |