Good time of the day to you all!
I have a problem with conditional formatting and really hope that someone could help
In the below table the formatting needs to be applied to the columns D, E, F
and it should be based on the values in columns A & C with the following condition:
I feel like I am missing something, an additional condition maybe or the order of the rules... I have tried to tweak the formulas, use $$ on the cells from columns A & C, but nothing seems to work.
Below I pasted a photo of the table and under it also an actual table, just for the reference.
I would really appreciate any help, and please tell me if I didn't explain myself well and I will try again.
Many thanks in advance!
I have a problem with conditional formatting and really hope that someone could help
In the below table the formatting needs to be applied to the columns D, E, F
and it should be based on the values in columns A & C with the following condition:
- if cell D4 >= cell A4, cell D4 needs to turn green
- if cell D4 <= cell C4, cell D4 needs to turn red
- if cell D4 =AND(D4<A4, D4>C4), cell D4 needs to turn yellow
I feel like I am missing something, an additional condition maybe or the order of the rules... I have tried to tweak the formulas, use $$ on the cells from columns A & C, but nothing seems to work.
Below I pasted a photo of the table and under it also an actual table, just for the reference.
I would really appreciate any help, and please tell me if I didn't explain myself well and I will try again.
Target & Limits (per month) |
|
| Results | Results | Results | ||
>=100% | 80-99% | <=79% | month 1 | month 2 | month 3 | ||
350 | 298 | 277 | 410 | 498 | 517 | ||
78 | 67 | 62 | 79 | 81 | 80 | ||
233 | 198 | 184 | 210 | 193 | 188 | ||
6700 | 5695 | 5293 | 5813 | 5879 | 5608 | ||
44 | 38 | 35 | 17 | 21 | 23 | ||
142 | 120 | 112 | 121 | 128 | 112 | ||
300100 | 255085 | 237079 | 311202 | 310040 | 308594 | ||
8850 | 7523 | 6992 | 8598 | 8591 | 8618 | ||
45% | 38% | 36% | 40% | 38% | 41% | ||
60% | 51% | 47% | 60% | 66% | 65% | ||
125033 | 106278 | 98776 | 369476 | 370906 | 370519 | ||
3033 | 2578 | 2396 | 8668 | 8726 | 8593 | ||
86700 | 73695 | 68493 | 93830 | 101437 | 75552 | ||
1867 | 1587 | 1475 | 1609 | 3072 | 1528 |
Many thanks in advance!