Conditional Formatting based on an already Conditionally Formatted Column

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,872
Office Version
365
Platform
Windows
Select B2 to last row of data & use this formula
=COUNTIFS(A:A,A2,B:B,B2)>1
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,872
Office Version
365
Platform
Windows
How can it highlight random numbers if col B is text?

Book1
AB
1
21296tyre
31296tyre
41296wheel
51297wheel
61297tyre
71297wheel
81298truck
91299truck
101299truck
111300truck
Report
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:B11Expression=COUNTIFS(A:A,A2,B:B,B2)>1textNO
 
Last edited:

FRESHShaZaM

New Member
Joined
Dec 30, 2019
Messages
7
Office Version
365
Platform
Windows, MacOS, Mobile
How can it highlight random numbers if col B is text?

Book1
AB
1
21296tyre
31296tyre
41296wheel
51297wheel
61297tyre
71297wheel
81298truck
91299truck
101299truck
111300truck
Report
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B2:B11Expression=COUNTIFS(A:A,A2,B:B,B2)>1textNO
I'm genuinely sorry, I don't know why I said "numbers." I tried it again, and the only difference now is that yours highlights all duplicates, whereas when I used it, only one of the duplicates was highlights. Although, the duplicated issue is still highlighted. Which is nonetheless, helpful, so thank you.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,872
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,095,954
Messages
5,447,531
Members
405,456
Latest member
melmelseh

This Week's Hot Topics

Top