Conditional Formatting - Highlighting Rows with Matching Cells in Multiple Columns

[ScottTemple]

Hello,

I would like to highlight an entire row using Conditional Formatting, when multiple cells in a row match, but across three columns. In the below example, only the last two rows would highlight as they have multiple matches in all three columns.

 

[awoohaw]

Okay, I have tweaked what I had before. I am not sure what I did differently to come up with a new formula, but this is better!

Book1
	E	F	G	H	I	J	K	L
1	Work Order	Coil #	Coil Wt		Building CF Formula
2
3	543051	1A1-1	317		FALSE	0	0	0
4	543518	31	251		FALSE	1	0	0
5	543518	29	304		FALSE	1	0	0
6	543454	35	308		FALSE	0	1	0
7	550053	35	342		TRUE	1	1	1
8	550053	35	342		TRUE	1	1	1
Sheet1

Cell Formulas
Range	Formula
I3:I8	I3	=SUM((--(SUM(--($E3=$E$3:$E$8))>1)) + (--(SUM(--($F3=$F$3:$F$8))>1)) + (--(SUM(--($G3=$G$3:$G$8))>1)))>1
J3:J8	J3	=(--(SUM(--($E3=$E$3:$E$8))>1))
K3:K8	K3	=(--(SUM(--($F3=$F$3:$F$8))>1))
L3:L8	L3	=(--(SUM(--($G3=$G$3:$G$8))>1))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E3:G13	Expression	=SUM((--(SUM(--($E3=$E$3:$E$8))>1)) + (--(SUM(--($F3=$F$3:$F$8))>1)) + (--(SUM(--($G3=$G$3:$G$8))>1)))>1	text	NO

 

[ScottTemple]

Sorry about not replying back sooner Awoohaw, I was away from work the past couple of weeks. I want to thank you for your assistance on this topic, but I think I'm going to pivot in a different direction as some of our data sheets will be changing in the near future.

 

[awoohaw]

Sorry about not replying back sooner Awoohaw, I was away from work the past couple of weeks. I want to thank you for your assistance on this topic, but I think I'm going to pivot in a different direction as some of our data sheets will be changing in the near future.

No worries. Good luck in the new direction.

But, you may want to uncheck the post your marked as a solution, it is not a solution. If there is one you believe helped, then please mark that one.
And it is okay if there isn't one in the thread, also.
Best wishes!

 

[ScottTemple]

Thanks for catching!