I require help with this formula. I want Excel to highlight row 8 in red if cells C9 through C16 have more than one occurrence of numbers 1, 2, 3, or 5 input (refer to the color chart in the attached image). Currently, the row only highlights the day of the week if it is the same number in the column. I need the row to be highlighted with any combination of 1, 2, 3, or 5 if they appear in the same row. This is for tracking scheduling purposes and will indicate if there are multiple individuals on vacation, sick, or leaving early. Please see the example attached. Columns F and G should be highlighted, but the formula does not recognize them unless it is the same number in a column.

=OR(COUNTIF(C9:C16,1)>1,COUNTIF(C9:C16,2)>1,COUNTIF(C9:C16,3)>1)

​I require help with this formula. I want Excel to highlight row 8 in red if cells C9 through C16 have more than one occurrence of numbers 1, 2, 3, or 5 input (refer to the color chart in the attached image). Currently, the row only highlights the day of the week if it is the same number in the column. I need the row to be highlighted with any combination of 1, 2, 3, or 5 if they appear in the same row. This is for tracking scheduling purposes and will indicate if there are multiple individuals on vacation, sick, or leaving early. Please see the example attached. Columns F and G should be highlighted, but the formula does not recognize them unless it is the same number in a column. =OR(COUNTIF(C9:C16,1)>1,COUNTIF(C9:C16,2)>1,COUNTIF(C9:C16,3)>1)  Read More

​