Hi,
I couldn’t find this from KB/FAQ, at least with the few searchwords I used. How do I create an “errorcheck” by comparing for example two cells sums, which should equal each other? And if they do’nt equal each other it informs about it in some way. Does it matter if the other sum is within a pivot?
Thankful again if someone have an answer to this.
-G-
C1: =IF(A1=B1;“Right”;“Wrong”)
As you can see in the sample of your first question Conditional sum, you can use the function =GETPIVOTDATA() to obtain data from pivot table without know the cell with the result in the pivot table.
Please take a quick read of the inner help, it’s very interesting for a first global vision about calc options, functions, etc; documentation about calc is available in Calc Guide
That’s great. Thank you I will do so. -G-
I have an additional question. Can I read from somewhere the textediting symbols? Like for example in this page when you want it in bold the **-symbol is used. What are the equivalents in calc/LibreOffice? And if I would like to have it pop up with bigger font, red-alert and yellow background 
? I think I add this as a new question so you can ignore these questions. -G-
To give format for the all cell, then you can use STYLE() function or a conditional format. For partially format the text, only direct format is possible, and doesn’t copyable with formulas.