Question

Can Conditional Formatting highlight and remove duplicate records?
1) True
2) False

Answer 1

Yes, Conditional Formatting can highlight and remove duplicate records in Excel.

Step-by-step explanation:

Yes, Conditional Formatting can highlight and remove duplicate records in Excel.

1. To highlight duplicates, select the data range you want to search for duplicates.
2. Go to the "Home" tab and click on "Conditional Formatting" in the "Styles" group.
3. Select "Highlight Cells Rules" and then click on "Duplicate Values".
4. Choose the formatting style and click "OK".

To remove duplicates, follow these steps:

1. Select the data range containing duplicates.
2. Go to the "Data" tab and click on "Remove Duplicates" in the "Data Tools" group.
3. Select the columns to check for duplicates and click "OK".