How to Hide Duplicated Values (conditional formatting)

We can use Excel conditional formatting to hide the duplicate values and make the list easier to read.

In this example, we will hide repeated values for the same company name.

Select range C2:C11 In Excel 2007, on the Ribbon's Home tab, click Conditional Formatting - New Rule - Use a Formula to Determine

Which Cells to Format Formula Is =C2=C1 Click the Format button and select a font colour to match the cell.