Conditional formatting question

[Carl Imthurn]

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

 

[Dodo]

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.

In Conditional format for cell F161:

=F161=MAX($F$161:$F$170) set the text colour to blue.

Add a second one

=F161=MIN($F$161:$F$170) and set the text colour to red.

Copy the conditional format to the cells F162 to F170.

 

[Carl Imthurn]

That did it -- thanks a bunch!

In Conditional format for cell F161:

=F161=MAX($F$161:$F$170) set the text colour to blue.

Add a second one

=F161=MIN($F$161:$F$170) and set the text colour to red.

Copy the conditional format to the cells F162 to F170.

 

[Morrigan]

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

=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]

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