if(right(c4,2)<=right(b4,2),(left(C4,4)-LEFT(b4,4))*12-(RIGHT(B4,2)-RIGHT(c4,2)),(left(C4,4)-LEFT(b4,4))*12+(RIGHT(c4,2)-RIGHT(b4,2))) 怎么在这里面加颜色,<12 标红色,(12-18)黄色,>18绿色还有一个 <0 就是过期 |
最佳回答 |
||||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|