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