- Try-it! Transcript Use the Quick Analysis tool to conditionally format cells in a range that have duplicate text, unique text, and text that is the same as text you specify
- For this, go to Home > Conditional Formatting > Highlight Cells Rule > Text that Contains
- Select first row of the table (A7:D7)
- 5