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?
[Solved] Change background to RGB values from cells
[Solved] Change background to RGB values from cells
Last edited by MrProgrammer on Mon Apr 15, 2024 8:50 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 4.1.3 on Windows
Re: Changing background to RGB values from cells
The macros can do it. Write your own macro function or subroutine.Is this something that can be done?
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.
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.
Re: Changing background to RGB values from cells
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.
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.