Conditional Formatting:

=SUMPRODUCT(($A$1:$A$10=$A1)*($B$1:$B$10=$B1))1


"pierre" wrote:

i have elements in column A and elements in column B
my goal is to be able apply a color for elements who show as duplicates
i.e :

column A column B

tree fork
tree fork

if "tree" and "fork" show twice , i want to make them appear as yellow color

So i have made a conditional format formula like this:
=SUMPRODUCT(--(($A$1:$A$100)&($C$1:$C$100)=A2&C2))1

MY QUESTION : is there a way to develop this formula in the same context ??
i mean i want more details like this :
---($A$1:$A$100=a2) and --($C$1:$C$100=c2)

please help