Hi!
I kindly ask for a little help. Any idea how to highlight values with conditional formatting?
For example: I would like highlight value within "Cycle times", if the total is bigger than value in "VMD payment terms".
For row 1 I should get highlighted "Cycle time 1" (116>30), for row 2 "Cycle time 4" (13+0+1+7=21 > 15) etc.
A B C D E F
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody><strike></strike>
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody><strike></strike>
I kindly ask for a little help. Any idea how to highlight values with conditional formatting?
For example: I would like highlight value within "Cycle times", if the total is bigger than value in "VMD payment terms".
For row 1 I should get highlighted "Cycle time 1" (116>30), for row 2 "Cycle time 4" (13+0+1+7=21 > 15) etc.
A B C D E F
Cycle time 1 | Cycle time 2 | Cycle time 3 | Cycle time 4 | Total cycle time | VMD payment terms |
116 | 3 | 0 | 2 | 121 | 30 |
13 | 0 | 1 | 7 | 21 | 15 |
40 | 2 | 5 | 2 | 49 | 30 |
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>
Many thanks!! | |||||
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>