I am looking perform conditional formatting dynamically.

I have the following table:

Rank 1 NAVY BLACK TAN CHRCL SPRUC
LONG 1.3
Reg 10.4 0 0.965
Short 6.5 1.855 1.53



Long x x x
Reg x x x x
Short x x x x


Where the x is an actual number. Essentially the spreadsheet will change
dynamically based on the Data that is populated. I am looking for a way to
use and ARRAY with conditional formatting. So in the example above, when
referring to Navy long, I would want conditional formats where Navy Long is
greater than X, but there may be 3 rows of Navy long or 50. I do not want to
have to set that each time. I will also have the same thing for Reg and
Short.

Chris