1. You are on Google Sheet. Click Format on the menu, then click Conditional formating... You will see Conditional format rules panel on right side.
2. On Conditional format rules panel, do as the below image then hit Done.
- A5:A345 : the range you want to highlight the duplicate cells.
- Formatting style: Choose the color to highlight the duplicates.
Hello, my name is Robin. I love a lot of things. I also love to share what I experienced and what I learned. I will represent them clearly,simply.
No comments:
Post a Comment