I
IanC
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,M33>K33*1.1))
Formula 2 =AND(K33>=0.014,OR(M33<K33*0.85,M33>K33*1.15))
Formula 3 =AND(K33<0.014,OR(M33<K33-0.002,M33>K33+0.002))
Set 2
Formula 1 =OR(M33<K33*0.9,M33>K33*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.
I have the following 2 sets of formulae which work independently
Set 1
Formula 1 =AND(K33>=0.1,OR(M33<K33*0.9,M33>K33*1.1))
Formula 2 =AND(K33>=0.014,OR(M33<K33*0.85,M33>K33*1.15))
Formula 3 =AND(K33<0.014,OR(M33<K33-0.002,M33>K33+0.002))
Set 2
Formula 1 =OR(M33<K33*0.9,M33>K33*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.