|
自 2021 年 1 月起,傳統文件類型將不再可用。您可以轉換傳統檔案或下載 PDF。進一步瞭解

Conditional formatting not working

已回覆
0

評論

1 條評論

  • Liz Habel

    Hi Barbara,

    Thank you for your question! The conditional formatting isn't working is because the condition isn't complete. Right now, this field is summing two values, but the formula needs a condition to test for to see if it's true or false (e.g. =sum(+B29, - B30)>0). In this example, if the sum of these values is not more than zero (formula is false), then it will apply the conditional formatting. If you have any questions about this, please let us know!

    Cheers!

    0

登入寫評論。