So you should select from A2 down to bottom right corner of range.... then with conditional formatting, you would select "use a formula to determine which cells to format" and enter a formula that points to row above... e.g. =A1>5. If done correctly, this will highlight A2 if A1 is greater than 5.... If you selected b2, c2, d2, etc.. the formula will adapt to those cells and highlight B2 if B1>5, C2 if C1>5, etc....