![]() Select 'Use a formula to determine which cells to format'.Ħ. On the Home tab, in the Styles group, click Conditional Formatting.ĥ. First, clear the previous conditional formatting rule.ģ. Execute the following steps to highlight triplicates only.ġ. ![]() Triplicatesīy default, Excel highlights duplicates (Juliet, Delta), triplicates (Sierra), etc. Note: select Unique from the first drop-down list to highlight the unique names. Click Highlight Cells Rules, Duplicate Values.Ĥ. On the Home tab, in the Styles group, click Conditional Formatting.ģ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |