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

2. 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. 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]
Cell Value is
greater than or equal to
=B3-.1
[Fomat]
Pattern(tab)
Select Yellow color
[ok]
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. [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.