Hello
I am struggling to work out the logic to determine a match between 2 dates, 2 products and one customer?
What I am trying to do is run a macro or formula to determine from the list where the SAME customer name (col A), matches with a RED & BLUE product with the same delivery date.
In the table below, I would want rows 4 & 5 to be highlighted as a match! And all other rows to be ignored.
Is anyone able to help me solve this conundrum?
Kind regards
Mike
<tbody>
</tbody>
I am struggling to work out the logic to determine a match between 2 dates, 2 products and one customer?
What I am trying to do is run a macro or formula to determine from the list where the SAME customer name (col A), matches with a RED & BLUE product with the same delivery date.
In the table below, I would want rows 4 & 5 to be highlighted as a match! And all other rows to be ignored.
Is anyone able to help me solve this conundrum?
Kind regards
Mike
A | B | C | ||
1 | CUSTOMER NAME | PRODUCT COLOUR | DELIVERY DATE | |
2 | Cust 1 | RED | FEB | |
3 | Cust 1 | RED | FEB | |
4 | Cust 2 | RED | MAR | |
5 | Cust 2 | BLUE | MAR | |
6 | Cust 2 | RED | MAR | |
7 | Cust 3 | BLUE | APR | |
8 | Cust 3 | RED | MAY | |
9 | Cust 4 | BLUE | AUG | |
10 | Cust 4 | BLUE | AUG | |
11 | Cust 4 | BLUE | SEP |
<tbody>
</tbody>