Hi,
I have below data & need to highlight the cells which have duplicate value in "A" as well as "B"&"C" column.
pl suggest.
I have below data & need to highlight the cells which have duplicate value in "A" as well as "B"&"C" column.
pl suggest.
| Location "A" | Material "B" | Qty"C" | Remarks |
| A1-02-01 | AAA | 9 | formula/condition should highlight this duplicate |
| b4-03-09 | XYZ | 31 | |
| b4-04-01 | ABC | 42 | |
| A1-02-01 | DDD | 28 | |
| C7-02-04 | AAA | 15 | |
| C7-02-05 | XYZ | 16 | formula/condition should highlight this duplicate |
| C7-02-05 | ABC | 30 | |
| C7-02-05 | XYZ | 16 | formula/condition should highlight this duplicate |
| A1-02-01 | DDD | 10 | |
| A1-02-01 | AAA | 9 | formula/condition should highlight this duplicate |
