Conditional formatting question

Carl Imthurn <nospam@all.com> wrote in
news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:

> 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 <nospam@all.com> wrote in
> news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:
>
>
>>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.
>
>

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

Morrigan wrote:

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

Carl Imthurn <nospam@all.com> wrote in
news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:

> 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 <nospam@all.com> wrote in
> news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:
>
>
>>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.
>
>

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

Morrigan wrote:

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

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

Morrigan wrote:

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

That did it -- thanks a bunch!

Dodo wrote:
> Carl Imthurn <nospam@all.com> wrote in
> news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:
>
>
>>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 <nospam@all.com> wrote in
news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:

> 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)

Carl Imthurn <nospam@all.com> wrote in
news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:

> 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)

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

Morrigan wrote:

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

That did it -- thanks a bunch!

Dodo wrote:
> Carl Imthurn <nospam@all.com> wrote in
> news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:
>
>
>>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 <nospam@all.com> wrote in
news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:

> 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 <nospam@all.com> wrote in
> news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:
>
>
>>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.
>
>

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

Morrigan wrote:

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

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

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

Morrigan wrote:

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

That did it -- thanks a bunch!

Dodo wrote:
> Carl Imthurn <nospam@all.com> wrote in
> news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:
>
>
>>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 <nospam@all.com> wrote in
news:ek3#xQFnFHA.3656@TK2MSFTNGP09.phx.gbl:

> 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)