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

[Keyboarding]

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!

[JohnSUN]

…and if you write “oae” then cell must be blue-red-orange like as “Aquafresh”?

[JohnSUN]

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

[charlie.it]

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

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

[Keyboarding]

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

[charlie.it]

I’m glad I was useful.

[Keyboarding]

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 ?