Thread: Finding Duplicated Number in Column B to A
View Single Post
 
Old 06-17-2024, 11:07 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
For your data picture ranges, select as shown, then conditional formatting as follows:


2024-06-17_190356.jpg

Extend the ranges for your whole data.
Reply With Quote