| IF(G2>3000,"<table height=0.3 width=" + ROUND(G2 * 1220 / sum(G2[!0;!0]), 2) + "% border=0 cellspacing=0 cellpadding=0.6>
<tr><td bgcolor=#FF786B><div align=right><font size='2' color=#FFFFFF>" + G2 + "</font></div></td></tr></table>","<table height=0.3 width=" + ROUND(G2 * 1220 / sum(G2[!0;!0]), 2) + "% border=0 cellspacing=0 cellpadding=0.6>
<tr><td bgcolor=#99FFFF><div align=right><font size='2' color=#FFFFFF>" + G2 + "</font></div></td></tr></table>") 单元格为正数时向右加了一个背景，想实现值为负数时向左加一个背景
|
1min目标场景问卷
立即参与
最佳回答 |
||||
|
0
|
|
|||
