Ask Your Question
0

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

asked 2014-08-21 11:20:14 +0100

Ghita_gmkl gravatar image

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-

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 12:36:18.209723

Comments

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?

Ghita_gmkl gravatar imageGhita_gmkl ( 2014-08-21 11:24:18 +0100 )edit

2 Answers

Sort by » oldest newest most voted
3

answered 2014-08-21 13:39:45 +0100

JohnSUN gravatar image

Use function STYLE() or Format-Conditional Formatting

wrong result.gif

edit flag offensive delete link more

Comments

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

Pedro gravatar imagePedro ( 2014-08-21 15:24:46 +0100 )edit

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

Ghita_gmkl gravatar imageGhita_gmkl ( 2014-09-02 11:09:30 +0100 )edit
1

answered 2014-08-21 13:13:53 +0100

Lupp gravatar image

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.

edit flag offensive delete link more

Comments

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

Ghita_gmkl gravatar imageGhita_gmkl ( 2014-09-02 11:09:38 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-08-21 11:20:14 +0100

Seen: 202 times

Last updated: Aug 21 '14