<\/span><\/h2>\n<\/p>\n
To find the same value in two columns in Excel, you can utilize the Conditional Formatting feature:<\/strong><\/p>\n<\/p>\n
<\/p>\n- Select the data range including both columns you want to compare.<\/li>\n
<\/p>\n
- Go to the “Home” tab in the Excel ribbon.<\/li>\n
<\/p>\n
- Click on “Conditional Formatting” and select “Highlight Cells Rules” from the drop-down menu.<\/li>\n
<\/p>\n
- Select “Duplicate Values” from the new menu.<\/li>\n
<\/p>\n
- In the “Duplicate Values” dialog box, ensure the “Duplicate” option is selected in the first drop-down list.<\/li>\n
<\/p>\n
- Choose the formatting style for the duplicate values if desired.<\/li>\n
<\/p>\n
- Click “OK” to apply the conditional formatting.<\/li>\n
\n<\/ol>\n
This will highlight any same values found in both columns, making them easily visible.<\/p>\n