There are more complicated formulas you can use to drill down and get more specific results, but for the purposes of this guide, we are using the simplest and quickest solution. It did, however, catch an all-caps version of the same word. Click Done Limitations of using this methodĪs you can probably see in the screenshot above, the formula failed to catch duplicates that are not an exact match, such as plurals.
Adjust the formatting style to your likingĨ. Enter the below custom formula =COUNTIF(RANGE,CRITERIA)>1 where RANGE is the column of the values you selected and CRITERIA is the first cell with data.ħ. In the “ Format rules” section, click on the drop-down and select “ Custom formula is“Ħ. Select the Single color tab on this sidebar, and confirm the range in the “ Apply to range” field matches your selected cellsĥ. Click on Format > Conditional FormattingĤ. Select the cells where you want to find duplicatesģ.
