Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how ??
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how ??
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|