Calc: informative text to be with specific markdowns (ex. bigger font, bold and different color if wrong)

[Ghita_gmkl]

In context to this:sums-comparison-for-error-check , but I add it as a separate question because hopefully it can be used anywhere if there is an answer to it?

Can I read from somewhere the textediting symbols? Like for example in this page when you want it in bold, or italic, the *-symbol is used. What are the equivalents in calc/LibreOffice?

Is it possible to have for example wrong result information to pop up with bigger font, red-alert and yellow background ? The question refers to this: C1: =IF(A1=B1;“Right”;“Wrong”)

Thanks again for any reply .
-G-

[Ghita_gmkl]

And I mean as added in the formula because then you don’t need to remember to choose those separately from the toolbar or with “shortcuts”, and it is less easy to accidentally remove those from ex. toolbar or with those “shortcuts”? Overdrive-mode possible?

[JohnSUN]

Use function STYLE() or Format-Conditional Formatting

[Pedro1]

Wow! Animated gifs! You just raised the bar in AskLibO! Kudos to you @JohnSUN

[Ghita_gmkl]

Thank you for this - it was much helpful. Both were. -G-

[Lupp]

Is it possible to have for example wrong result information to pop up with …

Without “macro programming” there are at least two ways. Both ways, of course, need a way to know if a “wrong result” occurred.

1. A formula contained in the cell that is expected to display the warning can then add a properly prepared cell style (See function STYLE()!).

2. Any cell or range can be conditionally formatted depending on any result implying that an error occurred.

[Ghita_gmkl]

Thank you for this - it was much helpful. Both were. -G-