Hello all,

I'm looking for assistance in the following problem, and would appreciate any and all suggestions/solutions. Thank you in advance!

Here is the situation:

1) I have dynamic data in two columns A & B, measuring 10 rows x 2 columns. (A1:A10 and B1:B10)

2) I have a column of whole numbers in A1:A10, and have found the maximum value using =MAX(A1:A10).

3) I would like to shade the two rows immediately below the maximum value: for example if the maximum was in cell A5, I would like A6:B6 and A7:B7 to be shaded.

Does anyone have suggestions on how to accomplish this task? I suspect conditional formatting and perhaps the OFFSET function might be used, but I'm really not too skilled in this area.

Much appreciated,
csaunders86