Find duplicate values fast
Finding duplicate values can be time consuming and frustrating. Leave the stress behind by applying conditional formatting and letting Excel do the work for you.
- Select the range of cells you think might contain duplicates.
- Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the Duplicate Values box, make sure that Duplicate is selected in the first drop-down box.
- Then select the format for duplicate values in the other drop-down box. Click OK. All the duplicate numbers or text are highlighted.
Apply conditional formatting based on text in a cell
- Select the cells you want to apply conditional formatting to. Click the first cell in the range, and then drag to the last cell.
- Click Home > Conditional Formatting > Highlight Cells Rules > Text that Contains. In the Text that Contains box, on the left, enter the text you want highlighted.
- Select the color format for the text, and click OK.
Copy conditional formatting
If you have a conditional formatting rule you want to use for new data, copy the conditional formatting to the new data using the Format Painter.
- Click a cell that has the conditional formatting you want to copy.
- Click Home > Format Painter. The pointer changes to a paintbrush. Double-click Format Painter if you want to copy the formatting to multiple selections.
- To copy the formatting, drag the mouse pointer across the cells or ranges of cells that you want to format.
- To stop the formatting, press Esc.