Results 1 to 4 of 4

Thread: Colour Ranges

  1. #1
    New Lounger
    Join Date
    May 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs down

    Hi,

    Please find attached a report where % ranges indicate the Colour.

    So the target is 95% for all students.

    How can I get excel to generate the colour (traffic light concept)?

    I'm not sure if this is a Maths question or an excel question, but if I'm to use a simple formula, do I calculate the % against the target (i.e. 95%), or against the whole (100%)?

    From my understanding, it's the target.

    TIA.

    Adam
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Welcome to the Lounge!

    This can probably be done with Format | Conditional Formatting, but it's not quite clear to me what you want the result to be. Could you provide an example of the desired end result? Thanks in advance.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You could use cond formatting as Hans suggested:

    Select A3:A7

    Format -cond formatting
    Cell Value is
    greater than or equal to
    =B3
    [Fomat]
    Pattern(tab)
    Select Green color
    [ok]
    [add]
    Cell Value is
    greater than or equal to
    =B3-.1
    [Fomat]
    Pattern(tab)
    Select Yellow color
    [ok]
    [add]
    Cell Value is
    less than
    =B3-.1
    [Fomat]
    Pattern(tab)
    Select red color
    [ok]
    [ok]

    This sets green at >=Target
    Yellow at <target and >=Target -0.1
    Red is < target -0.1

    As to what they want for the ranges and how to calculate it, that is up to you and whomever is designing it.

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='AdamkSmith' post='775677' date='18-May-2009 18:54']Hi,

    Please find attached a report where % ranges indicate the Colour.

    So the target is 95% for all students.

    How can I get excel to generate the colour (traffic light concept)?

    I'm not sure if this is a Maths question or an excel question, but if I'm to use a simple formula, do I calculate the % against the target (i.e. 95%), or against the whole (100%)?

    From my understanding, it's the target.

    TIA.

    Adam[/quote]

    Not so clear as what you want to achieve, but see attached if this is waht you are after
    this assume there is no blanks
    Attached Files Attached Files
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

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