+ Reply to Thread
Results 1 to 10 of 10

Conditional formatting question

  1. #1
    Dodo
    Guest

    Re: Conditional formatting question

    Carl Imthurn <[email protected]> wrote in
    news:ek3#[email protected]:

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

  2. #2
    Carl Imthurn
    Guest

    Re: Conditional formatting question

    That did it -- thanks a bunch!

    Dodo wrote:
    > Carl Imthurn <[email protected]> wrote in
    > news:ek3#[email protected]:
    >
    >
    >>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.
    >
    >



  3. #3
    Carl Imthurn
    Guest

    Re: Conditional formatting question

    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

    >
    >
    >



  4. #4
    Dodo
    Guest

    Re: Conditional formatting question

    Carl Imthurn <[email protected]> wrote in
    news:ek3#[email protected]:

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

  5. #5
    Carl Imthurn
    Guest

    Re: Conditional formatting question

    That did it -- thanks a bunch!

    Dodo wrote:
    > Carl Imthurn <[email protected]> wrote in
    > news:ek3#[email protected]:
    >
    >
    >>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.
    >
    >



  6. #6
    Carl Imthurn
    Guest

    Re: Conditional formatting question

    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

    >
    >
    >



  7. #7
    Carl Imthurn
    Guest

    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


  8. #8
    Dodo
    Guest

    Re: Conditional formatting question

    Carl Imthurn <[email protected]> wrote in
    news:ek3#[email protected]:

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

  9. #9
    Carl Imthurn
    Guest

    Re: Conditional formatting question

    That did it -- thanks a bunch!

    Dodo wrote:
    > Carl Imthurn <[email protected]> wrote in
    > news:ek3#[email protected]:
    >
    >
    >>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.
    >
    >



  10. #10
    Carl Imthurn
    Guest

    Re: Conditional formatting question

    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

    >
    >
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1