Forum Discussion
AKampianakis
Apr 08, 2022Copper Contributor
Duplicates Highlight with conditional rule for range
Hello, I would like to make a calculation or find a way to do this: in the picture above I have 2 different columns. 1 is Machines , and the other is Product. I would like to highlight the...
OliverScheurich
Apr 08, 2022Gold Contributor
=AND(COUNTIFS($B$2:$B$11,$B2,$A$2:$A$11,"A1")>0,COUNTIFS($B$2:$B$11,$B2,$A$2:$A$11,"A2")>0)Maybe with this rule for conditional formatting.