Conditional formatting question
 

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

Carl Imthurn wrote in
:

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.


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

That did it -- thanks a bunch!

Dodo wrote:
Carl Imthurn wrote in
:


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.

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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=394014

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