Ask Your Question
1

Can LibreOffice Calc auto-colorize the background of cells *as I type* inside them depending on the letters they contain ?

asked 2017-08-14 04:49:34 +0100

Keyboarding gravatar image

updated 2017-08-14 04:53:21 +0100

Hi everyone,

Do you know if LibreOffice Calc can auto-colorize the background of cells as I type inside them depending on the letters they contain ?

If it contains an "a" it would be red, If it contains an "e" it would be orange If it contains an "i" it would be yellow If it contains an "o" it would be green if it contains an "o" it would be blue,

but without having to stop the typing, go into a menu and hit apply:

It would be set beforehand once and for all, always active, altering the typed content's background color in realtime ?

Thanks IMMENSELY for spreading the colorized magic!

edit retag flag offensive close merge delete

Comments

...and if you write "oae" then cell must be blue-red-orange like as "Aquafresh"?

JohnSUN gravatar imageJohnSUN ( 2017-08-14 06:39:55 +0100 )edit

And answer is - "Yes, it can be done with Condition Formatting and function STYLE()"

JohnSUN gravatar imageJohnSUN ( 2017-08-14 07:25:16 +0100 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2017-08-14 08:24:50 +0100

updated 2017-08-14 08:26:01 +0100

Ciao, please see Condition Formatting in this attached: Colors.ods

If my answer helped you, vote it with ✔ (here on the left)

image description

edit flag offensive delete link more
0

answered 2017-08-14 08:57:27 +0100

Keyboarding gravatar image

Chaaaaaaarlie! You're the boss! Thank you so much!

edit flag offensive delete link more

Comments

I'm glad I was useful.

charlie.it gravatar imagecharlie.it ( 2017-08-14 10:21:16 +0100 )edit

As I edit, delete, cut, copy and paste cell content and lines, the conditional formatting gets duplicated and messed up. I then go in the dialog box to delete all duplications of the conditional formatting, leaving only one, then reset its range by typing for example : A1:ZZ9999. Is there a simpler way to do this, maybe a way of locking the conditional formating so that regular editing doesn't scramble it ?

Keyboarding gravatar imageKeyboarding ( 2017-08-27 14:44:03 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-08-14 04:49:34 +0100

Seen: 86 times

Last updated: Aug 14 '17