Conditional formatting with a % tolerance

Good afternoon all. I hope Friday is treating you well.

I have attached a sample of a workbook. It's a standard RAG table showing a baseline for "clearance times" of incidents, with one month's results RAG'ged to that baseline. What I'm trying to work out is how I do the following:

Green for LESS than the baseline
Red for MORE than the baseline
Amber for 5% EITHER SIDE of the baseline, whether that's 5% more or 5% less.

I've tried to run various formulae in the conditional formatting window but failed miserably.

Assistance will be met with my sincere best wishes for the bank holiday weekend and the promise of a beer if I ever meet you, however unlikely that seems.

Having highlighted C2:C13 your three formula based rules would be:

1: RED
=AND(ISNUMBER($C2),$C2>$B2*1.05)

2: GREEN
=AND(ISNUMBER($C2),$C2<$B2*0.95)

3: AMBER
=ISNUMBER($C2)

Select C2:C13 and invoke CF...

1. Cell Value Is >> Between >> =$B2-$B2*0.05 and =$B2+$B2*0.05

Click Format and choose Amber... click Ok

Click Add

2. Cell Value Is >> Less Than >> =$B2

Click Format and choose Green... clck Ok

Click Add

3. Cell Value Is >> Greater Than >> =$B2

Click Format and choose Red.. click Ok

Click Ok

The references to $C should become C ... ie relative, $B should remain as this column is fixed for all others (ie all refer to B for evaluation).

Only from the references to column C.. e.g $C2 should become C2

If you use my version, no changes required when copy/paste