Thanks Morrigan -- that worked also.
You guys are great.

Morrigan wrote:

Select those 10 numbers with cell F161 being the active cell, formulas
a

=IF(SMALL($F$161:$F$170,1)=F161,1,0) (Red)
=IF(LARGE($F$161:$F$170,1)=F161,1,0) (Blue)

Hope it helps


Carl Imthurn Wrote:

Hi folks --

I've read through a number of the posts on conditional formatting, and
I apologize in advance
for not getting the hang of it yet.
Here's my problem: I have a column of ten numbers as follows:

23
2
0
15.2
8
44.3
110
99.5
53.7
110.1

What I want to do is format the low value to appear in RED (0 in this
case)
and the high value to appear in BLUE (110.1 in this case).
for what it's worth, the values are in cells F161 to F170.

Thanks in advance --

Carl