I have data in cells A1 through D10 and in column F( F1:F10) I have the averages of each row. I'd like to loop through the range of cells (A1 to D10) and within each row (10 rows) I want to compare the cell value to the corresponding row value in column F(average which is already computed.) Thanks in advance!

I have this so far:

For Each c In Worksheets("Sheet1").Range("a1:d10").Cells
[code to compare c.value to its corresponding F column value]
Next