Simple Conditional Formatting Problem

nburaq

Board Regular
Joined
Apr 2, 2021
Messages
220
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Gents,
I am dialing with a simple conditional formatting issue but I have not found a solution so far. Here is my problem;
  • I have two columns in my sheet namely; Group and No and every column has its own value (similar or different)
  • I would like to highlight values if concatenate value of two columns is the same ( In one column, it is really easy)
  • However, I do not want to do this job by creating a 3rd column which includes concatenate value of these two columns
IP2022_2ndbatch.xlsx
AB
1GroupNo
2A10
3A12
4A5
5B20
6B15
7B18
8A12
9B20
Sheet2



Thanks for all help and comments in advance!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Select the range A2:B9, then enter in this Conditional Formatting formula:
Excel Formula:
=countifs($A$2:$A$9,$A2,$B$2:$B$9,$B2)>1
and select your red background color.
 
Upvote 0
Solution
How about
+Fluff 1.xlsm
AB
1GroupNo
2A10
3A12
4A5
5B20
6B15
7B18
8A12
9B20
10
11
12
13
Main
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:B13Expression=AND($A2<>"",SUMPRODUCT(--($A$2:$A$20&$B$2:$B$20=$A2&$B2))>1)textNO
 
Upvote 0
What a great community! Both solutions work perfectly! Thanks Joe4 and Fluff!
 
Upvote 0
You are welcome!
Glad we were able to help!
 
Upvote 0

Forum statistics

Threads
1,213,553
Messages
6,114,279
Members
448,562
Latest member
Flashbond

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