Hi!

Try this:

Assume the range of cells is A2:E21

Select the range A2:E31
Goto Format>Conditional Formatting
Condition 1
Formula Is: =AND(ISNUMBER(A2),A2=MIN($A2:$E2))
Click the Format button
Select the style(s) desired
Click OK
Click Add
Condition 2
Formula Is: =AND(ISNUMBER(A2),A2=MAX($A2:$E2))
Click the Format button
Select the style(s) desired
OK your way out.

If all the numbers are the same in any row they will be both the MIN and the
MAX for that particular row. Since condition 1 is defined first and is set
for the MIN, that style will be applied.

Biff

The procedure behind copying the conditional format formulas to the entire
range, is exactly the same procedure as copying any other formula down a
column or across a row ... place your absolutes at the right reference
points.

Say your range is A1 to Z20.

Select the *entire* range.

Change "Cell Value Is" to "Formula Is", and enter this:

=A1=MAX($A1:$Z1)
Choose your format.

Then, click "Add" for condition 2,

Change "Cell Value Is" to "Formula Is", and enter this:

=A1=MIN($A1:$Z1)
And choose your format for this condition.

<OK> your way out, and you're done!

depending upon how you have you data set up
in the conditional formatting box select the = formula option

using a1 as an example

=a1=min($a1:$Z1)

the $ sumbol stops the col's a to z from Moving when you conditionally paste
the format to the other cells