Conditional Formatting - Highlighting Rows with Matching Cells in Multiple Columns

ScottTemple

Board Regular
Joined
Dec 28, 2023
Messages
103
Office Version
  1. 365
Platform
  1. Windows
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.

1706622142242.png
 

Attachments

  • 1706622094200.png
    1706622094200.png
    8.5 KB · Views: 7
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
EFGHIJKL
1Work OrderCoil #Coil WtBuilding CF Formula
2
35430511A1-1317FALSE000
454351831251FALSE100
554351829304FALSE100
654345435308FALSE010
755005335342TRUE111
855005335342TRUE111
Sheet1
Cell Formulas
RangeFormula
I3:I8I3=SUM((--(SUM(--($E3=$E$3:$E$8))>1)) + (--(SUM(--($F3=$F$3:$F$8))>1)) + (--(SUM(--($G3=$G$3:$G$8))>1)))>1
J3:J8J3=(--(SUM(--($E3=$E$3:$E$8))>1))
K3:K8K3=(--(SUM(--($F3=$F$3:$F$8))>1))
L3:L8L3=(--(SUM(--($G3=$G$3:$G$8))>1))
Cells with Conditional Formatting
CellConditionCell FormatStop If True
E3:G13Expression=SUM((--(SUM(--($E3=$E$3:$E$8))>1)) + (--(SUM(--($F3=$F$3:$F$8))>1)) + (--(SUM(--($G3=$G$3:$G$8))>1)))>1textNO
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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.
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top