Highlight Duplicate records on specific condition

[Ehtisham Ali]

Hi Guys,

I again need your help VBA experts.

I have a data spread across col A to Col D.

What I want.
On basis of CI Names(colB) I want to highlight all duplicate RFO(colD).

Please find attached sheet. Please come up with a simple code so that I can understand and make modifications whenever required.

Looking forward for your prompt reply.

 

[Khalid NGO]

Hi Ali,

If VBA not necessary, you can use Conditional Formatting...

Select your range D2:D168
Go to Conditional Formatting
Formula:
=COUNTIF($B$2:$B$168,$B2)>1

Set desire format

Regards,

 

[Ehtisham Ali]

Hi Ali,

If VBA not necessary, you can use Conditional Formatting...

Select your range D2:D168
Go to Conditional Formatting
Formula:
=COUNTIF($B$2:$B$168,$B2)>1

Set desire format

Regards,

I hope I am not very clear with my problem because your solution is something different.

Let me brief my problem again.

Let suppose I found duplicate in CI(colB) now check if any duplicate RFO is their for those 3 or 4 CI's , if yes than only highlight that RFO.

I hope I am clear now.

 

[Khalid NGO]

Ali,
I did as you wrote

On basis of CI Names(colB) I want to highlight all duplicate RFO(colD)

Perhaps I've misunderstood, can you include the expected result manually filled color?
This will help others to offer targeted solutions.

Regards,

 

[NARAYANK991]

Hi Ali ,

Something like this ?

Narayan

 

[Ehtisham Ali]

Hi Ali ,

Something like this ?

Narayan

At first glance it seems perfect !

Please allow me some time to verify.

Very smart solution and same without VBA. Thanks Narayan

 

[Ehtisham Ali]

Hi NARAYANK991

Thanks for your efforts and awesome solution to the problem. It is indeed a very easy yet powerful solution.

Thanks once again