Excel Gurus of the World,

I have an inquiry about excel conditional formatting.

I have a spreadsheet with about 30 Columns and 300 Rows. Column 31 contains the average for each row.

What I am trying to do is in this example is if cells in row 2 are above the average for row 2 in column 31, then change color of cell to red with red text.

I was going row by row because each row had a different average. Is there a quicker way than the way I am doing it?

-Thank You!