Complicated conditional formatting
 

I have a complicated set of conditions I need conditional formatting for.

I have the following 2 sets of formulae which work independently
Set 1
Formula 1 =AND(K33=0.1,OR(M33<K33*0.9,M33K33*1.1))
Formula 2 =AND(K33=0.014,OR(M33<K33*0.85,M33K33*1.15))
Formula 3 =AND(K33<0.014,OR(M33<K33-0.002,M33K33+0.002))

Set 2
Formula 1 =OR(M33<K33*0.9,M33K33*1.1)

Obviously for the second "set" I could have used Cell is not between, but
for this requirement a formula will be necessary.

There are 3 complications:
1. I need to use set 1 if K31 begine with "ti" and set 2 if K31 begins with
"ma".
2. I need to copy the formatting down several rows whilst still referencing
K31. I can't use K$31 because of complication 3.
3. The cells need to be copied to another sheet (programmatically) but will
not occupy the same rows (columns remain the same).

I would rather not achieve this programmatically, as the programming is
already very complex (for me, at least) and I'd rather not introduce any
further complications to it.

--
Ian
--