https://bugs.documentfoundation.org/show_bug.cgi?id=157033
Kira Tubo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC| |[email protected] --- Comment #2 from Kira Tubo <[email protected]> --- Hi @CnPx, Thank you for reaching out. There are a couple of things that I noticed may be of help to you: 1. Highlighting a cell based on its value: Are you referring to Conditional formatting? If you go to Format > Conditional > Condition, you can specify a cell or a range of cells to be highlighted in any color/font effect that you would like. There is a link mentioned in Comment 1 earlier: https://help.libreoffice.org/latest/en-US/text/scalc/guide/cellstyle_conditional.html?DbPAR=CALC#bm_id3149263 2. Adding (5+5) and (A1+A2) without requiring =SUM function: If you put an equal sign in front of these, e.g. =5+5 and =A1+A2, it will add up the values for you. No need to use an actual function like =SUM. I'm not sure about the rest of the ask, but once you clarify with some steps, and maybe some screenshots if possible, it will be easier for us to understand. If there is more than one bug or enhancement request (to me it's not clear at the moment if there is), then it's possible that they will need to be filed in a separate report, so we can review each individual ask separately. I hope this helps! I will change the Status to NEEDINFO as we wait for your answer. Please change it back to UNCONFIRMED once you respond. -- You are receiving this mail because: You are the assignee for the bug.
