Question

20. How can conditional formatting be used to identify duplicates in Excel? Write the

steps
​

Answer 1

Select the cells you want to check for duplicates. ...

Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

In the box next to values with, pick the formatting you want to apply to the duplicate values, and then click OK