Excel automatically copies the formula to the other cells. Always write the formula for the upper-left cell in the selected range (A1:C10). Excel highlights the triplicate names.Įxplanation: = COUNTIF($A$1:$C$10,A1) counts the number of names in the range A1:C10 that are equal to the name in cell A1. 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 kommentar(er)
