Conditional Formatting 3 way 2 criteria XL2007

[rds]

Hi Excel people !

I've tried a few times but I can't figure it out.

With the help of conditional Formatting I would like to check if a KPI is on target.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
The methode I'd like to use is "traffic light" methode.<o></o>
The conditional formatting should be created based on a match with 2 criteria. <o></o>
The first criteria is that the cel with the formatting searches in the correct quarter. (Tried to do that with line 4.)<o></o>
Second criteria, once the first match is found, Excel should apply conditional formatting.<o></o>
<o></o>
<o> </o>
<o></o>
When the value in the cel >=1,1* target the traffic light should be turned RED.<o></o>
When the value in the cel <1,1 * target, but >=1,0 * target then the traffic light should turn to Orange.<o></o>
When the value in the cel <1,0 * target the traffic light should turn to Green.<o></o>


I've tried to attached a file so you can see were the problem is but I'd have to find somewhere to upload my file.

 

[rds]

http://www.helpmij.nl/forum/attachment.php?attachmentid=118715&d=1295350184

There is an attachment in the link. Not sure if you're able to retrieve it.