Select the range you want to check for duplicates. This can be a single column/row, multiple columns/rows, or group of highlighted cells.

Click "Conditional Formatting," then "Highlight Cells Rules," and click on "Duplicate Values..." to open a pop up window.

Choose how you would like the duplicated data to be displayed, then click "OK" to close the window.

Click "Light Red Fill with Dark Red Text"

This guide provides a step-by-step process for checking if two columns have the same values in Excel. It explains how to select the range, apply conditional formatting, and view the duplicates, making it easy to identify any matching values.

Want to make guides like this in seconds? Yes, it's really that fast.