Conditional Formatting time with a range applied

Hi all, im hoping you can help me solve this problem.

Below are three problems im struggling to solve. Can you help?

• Person 'A' has to hit a target of 02:30:00 weekly. Should they exceed the target but be within 10% - either side - this will display in GREEN. How can this be setup in the conditional formatting?

• Person 'B' has to hit a target of 02:30:00 weekly. Should they exceed the 10% tolerance - either side - and post anything between 11% and 15% this will display in Orange.
How can this be setup in the conditional formatting?

• Person 'C' has to hit a target of 02:30:00 weekly. Should they exceed the tolerance by 16% and greater - either side - this will display in Red.

How can this be setup in the conditional formatting?

Just to note: the weekly target does change from one person to the next.

Thanks all

Andy

Hi Amit, thanks for the mega fast reply, very much appreciated.

It would appear to work apart from the RED formula for greater than 16%. Please see the image attached to see the colour applied based on the formula for Red.
\1

Hi again and thanks for your help.

I have moved the conditional formatting as mentioned from Amit which id completely overlooked so i do apologise. This seems to have fixed the problem but ive now inherited another lol.

The conditional formatting appears to miss timings between percentage values so some times are going unnoticed.

I have attached the file as requested to see if you can resolve my problem.

[attach]http://www.excelforum.com/newattachment.php?do=manageattach[/attach]

Thank you again

Andy

Thank so much for looking at my attached file and discovering the problem was due to mistakes I made. Now you've explained the problem, im kicking myself for not recognising it myself. Done the changes suggested and everything is working spot on.

Thank you very much, really glad I joined this forum.

Andy