If then formula help

[ronicaroman]

Please help identify the write formula to return values in column D. The idea is that if people share the same number in column B and the same color in column C, column D should be "true". If they have the same number in column B but different colors in column C, the value in column D should be false.

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl67, width: 64"]A[/TD]
[TD="class: xl67, width: 64"]B[/TD]
[TD="class: xl67, width: 64"]C[/TD]
[TD="class: xl67, width: 64"]D[/TD]
[/TR]
[TR]
[TD="class: xl68"]Tim[/TD]
[TD="class: xl68"]654[/TD]
[TD="class: xl68"]Red[/TD]
[TD="class: xl67"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl68"]Becky[/TD]
[TD="class: xl68"]654[/TD]
[TD="class: xl68"]Red[/TD]
[TD="class: xl67"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl68"]Susan[/TD]
[TD="class: xl68"]23[/TD]
[TD="class: xl68"]Green[/TD]
[TD="class: xl67"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl68"]Nancy[/TD]
[TD="class: xl68"]23[/TD]
[TD="class: xl68"]Green[/TD]
[TD="class: xl67"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl68"]Ruben[/TD]
[TD="class: xl68"]23[/TD]
[TD="class: xl68"]Green[/TD]
[TD="class: xl67"]TRUE[/TD]
[/TR]
[TR]
[TD="class: xl68"]David[/TD]
[TD="class: xl68"]7899[/TD]
[TD="class: xl68"]Blue[/TD]
[TD="class: xl67"]FALSE[/TD]
[/TR]
[TR]
[TD="class: xl68"]Mike[/TD]
[TD="class: xl68"]7899[/TD]
[TD="class: xl68"]Purple[/TD]
[TD="class: xl67"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Try in D1:

=COUNTIFS($B$1:$B$7,B1,$C$1:$C$7,C1)>1

 

[ronicaroman]

Thank you so much!

 

[Eric W]

You're welcome!

Thanks for the feedback.