Click start of column c > conditional formatting > create a new rule > use a formula to determine the cells to be formatted >; To format the values that conform to this formula, please fill in the formula =COUNTIF(C:C, C 1)> 1
Format > Fill > Select yellow and confirm.
or
Format > font > color > select red and confirm.