Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated!! - Conditional formatting with nested function | Excel Worksheet Functions | |||
Complicated formatting | Excel Discussion (Misc queries) | |||
Complicated conditional formatting if numbers match across a data set..How? | Excel Worksheet Functions | |||
Complicated conditional formatting if numbers match across a data set..How? | Excel Discussion (Misc queries) | |||
Complicated conditional "countif" formula | Excel Discussion (Misc queries) |