[Solved] Change background to RGB values from cells

Discuss the spreadsheet application
Post Reply
ProfAlba
Posts: 1
Joined: Sat Apr 06, 2024 11:08 pm

[Solved] Change background to RGB values from cells

Post by ProfAlba »

I'm wanting to have cell backgrounds to change to a specific colour using RGB values from other cells.

For example, I have three cells each with a number for red, green and blue and I would like to use those values to change the background so I can visualize what colour it is directly in the spreadsheet.

Is this something that can be done?
Last edited by MrProgrammer on Mon Apr 15, 2024 8:50 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 4.1.3 on Windows
User avatar
Zizi64
Volunteer
Posts: 11365
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Changing background to RGB values from cells

Post by Zizi64 »

Is this something that can be done?
The macros can do it. Write your own macro function or subroutine.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
Posts: 11365
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Changing background to RGB values from cells

Post by Zizi64 »

Here is a similat topic with macro code snippets and an Extension (.oxt):

viewtopic.php?t=98070
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply