akampianakis
New Member
- Joined
- Apr 8, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hello world,
so I have the sheet as seen in the attachment (I have included a picture)
I have 2 columns, A for machines, B for products. I want to highlight those products that are created from both machines , so something like if duplicate and column A in the range of the duplicates contains both A1 and A2, highlight the range/cell, or something that identifies that.
Is that possible?
Thanks!
so I have the sheet as seen in the attachment (I have included a picture)
I have 2 columns, A for machines, B for products. I want to highlight those products that are created from both machines , so something like if duplicate and column A in the range of the duplicates contains both A1 and A2, highlight the range/cell, or something that identifies that.
Is that possible?
Thanks!