Excel: Compare multiple columns to see if less than value in another column for all rows

I am trying to compare data across multiple columns to see if each cell is less than a value in a single cell on the same row.

Column B contains the mean across all employees for the variable in Column A (there are 12 variables). Columns C through N contain the mean for each individual employee. For each of the variables, I would like to highlight the cell for employees whose mean is less than the mean of all employees.

I can figure out how to do this for each row (compare the values in columns C through N with the value in column B) using conditional formatting using a formula:

If Cell Value is <$B$2, apply highlighting to =$C$2:$N$2.

I don't want to have to do this row by row if at all possible.

Recent Questions...