Set cell colour based on other cell colour
Set cell colour based on other cell colour
This question may have already been answered but is it possible to change the value on a cell (eg from 0 to 1 to 2 etc...) by picking up the change of colour from another cell?
Let's say I have a row or column of text or numbers (I know it sounds vague but bare with me) and when a cells text colour changes from say black to cyan, I want to have a seperate cell pick up the colour change of that cell by a value of 1 (0-1). If it's two or more cells then I would like it to pick up the colour change of those two or more cells by a total value of 2 or more (2-3-4...and so on).
Is that possible?
Any help appreciated, thanks in advance.
Marcus.
Let's say I have a row or column of text or numbers (I know it sounds vague but bare with me) and when a cells text colour changes from say black to cyan, I want to have a seperate cell pick up the colour change of that cell by a value of 1 (0-1). If it's two or more cells then I would like it to pick up the colour change of those two or more cells by a total value of 2 or more (2-3-4...and so on).
Is that possible?
Any help appreciated, thanks in advance.
Marcus.
OpenOffice.org 2.0 on Windows 7 (64 bit)
Re: Set cell colour based on other cell colour
Welcome to the forums.
Detecting the colour of a cell can, if I recall correctly, only be done with sophisticated macro programming.
It's a lot easier to change the colour of a cell based on the entry of, either, that cell, or another cell.
How are you setting the colour currently? Is it manually set or is it based on the entry into that cell (using Conditional Formatting)?
If you are using Conditional formatting, then you can use the same, or a similar, formula to set the cell value that you seem to be asking about.
Detecting the colour of a cell can, if I recall correctly, only be done with sophisticated macro programming.
It's a lot easier to change the colour of a cell based on the entry of, either, that cell, or another cell.
How are you setting the colour currently? Is it manually set or is it based on the entry into that cell (using Conditional Formatting)?
If you are using Conditional formatting, then you can use the same, or a similar, formula to set the cell value that you seem to be asking about.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Set cell colour based on other cell colour
Thanks for the reply.
Ok, that sounds a bit like assigning format by formula, that's colouring a cell depending on its value. I'd like to flip that around so I can value a cell by colour, more specifically colour change. Think of it like a "clicker" to keep track of a change of colour from black to cyan or green to red etc. I'm inputting manually by the way.
Conditional formatting is all very well but how would I (if I could) use that to have a cell automatically click up in increments of 1 for every cell that changes colour.
I can do cell count with a simple formula like: =COUNT(A1:A66) counting only the cells with numbers. Anything like that?
Ok, that sounds a bit like assigning format by formula, that's colouring a cell depending on its value. I'd like to flip that around so I can value a cell by colour, more specifically colour change. Think of it like a "clicker" to keep track of a change of colour from black to cyan or green to red etc. I'm inputting manually by the way.
Conditional formatting is all very well but how would I (if I could) use that to have a cell automatically click up in increments of 1 for every cell that changes colour.
I can do cell count with a simple formula like: =COUNT(A1:A66) counting only the cells with numbers. Anything like that?
OpenOffice.org 2.0 on Windows 7 (64 bit)
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Set cell colour based on other cell colour
Hi, and welcome to the forum.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
No. Calc's functions and formulas operate on cell values. Read section 9. Using functions and cell ranges in Ten concepts that every Calc user should know.Mpl82 wrote:Conditional formatting is all very well but how would I (if I could) use that to have a cell automatically click up in increments of 1 for every cell that changes colour. … Anything like that?
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: Set cell colour based on other cell colour
Do you mean inputting manually colours or numbers?Mpl82 wrote:I'm inputting manually by the way
How does the cell change its colour?
And, How many colors do you need to use?
libreoffice 6.2 on windows10
Re: Set cell colour based on other cell colour
Ok. So changing the cell colour, be it background or text, will not initiate a change in value to another cell?MrProgrammer wrote:Hi, and welcome to the forum.
No. Calc's functions and formulas operate on cell values. Read section 9. Using functions and cell ranges in Ten concepts that every Calc user should know.Mpl82 wrote:Conditional formatting is all very well but how would I (if I could) use that to have a cell automatically click up in increments of 1 for every cell that changes colour. … Anything like that?
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
I know it can be done the opposite way because I've just done it using conditional formatting, but if there's no option for it than I appreciate your input all the same. Cheers.
Marcus.
OpenOffice.org 2.0 on Windows 7 (64 bit)
Re: Set cell colour based on other cell colour
Hi Raxell.raxell wrote:Do you mean inputting manually colours or numbers?Mpl82 wrote:I'm inputting manually by the way
How does the cell change its colour?
And, How many colors do you need to use?
Both. I'm inputting the colour changes manually but hoping to have a cell automatically keep track of the changes for each colour changing cell. Mainly green, cyan and grey. Cheers.
Marcus.
OpenOffice.org 2.0 on Windows 7 (64 bit)
Re: Set cell colour based on other cell colour
That is another way of saying what MrProgrammer said. Functions and formulae operate on cell values, not formats.So changing the cell colour, be it background or text, will not initiate a change in value to another cell?
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: Set cell colour based on other cell colour
Please update your signature in this forum. I can not believe that you use such obsolete OO.o version.OpenOffice.org 2.0 on Windows 7 (64 bit)
You can modify the STYLE of a cell based on the VALUE of other cell.
In all of other cases need some macro programming to achieve this task.
Note: you can determine the color properties of the cells - formatted by a style or manually (directly) - by your macro, except the color properties of the conditionally formatted cells. No way to determine the actually applied style of the conditionally formatted 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.
Re: Set cell colour based on other cell colour
Funnily enough as soon as I posted it, I read it back and just realized. Cheers.robleyd wrote:That is another way of saying what MrProgrammer said. Functions and formulae operate on cell values, not formats.So changing the cell colour, be it background or text, will not initiate a change in value to another cell?
Marcus.
OpenOffice.org 2.0 on Windows 7 (64 bit)
Re: Set cell colour based on other cell colour
Yeah I seldom use oo calc so hadn't bothered updating. It's not obsolete for what I'm doing.Zizi64 wrote:Please update your signature in this forum. I can not believe that you use such obsolete OO.o version.OpenOffice.org 2.0 on Windows 7 (64 bit)
You can modify the STYLE of a cell based on the VALUE of other cell.
In all of other cases need some macro programming to achieve this task.
Note: you can determine the color properties of the cells - formatted by a style or manually (directly) - by your macro, except the color properties of the conditionally formatted cells. No way to determine the actually applied style of the conditionally formatted cells.
Ok I'll give that a go, if I can't do it on this one I'll update and try it. Cheers.
Marcus.
OpenOffice.org 2.0 on Windows 7 (64 bit)
Re: Set cell colour based on other cell colour
It is obsolete for support - there may well be differences in features that most of the helpers here may not be aware of, given the version you claim to be using was released in 2005.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
-
- Posts: 145
- Joined: Mon Jun 13, 2016 10:50 am
Re: Set cell colour based on other cell colour
Hi,
For anyone interested, there is an extension (of mine ) that provides some help for this kind of problems : COUNTSTYLE.
Regards.
For anyone interested, there is an extension (of mine ) that provides some help for this kind of problems : COUNTSTYLE.
Regards.
AOOo 4.1.2 on Win7 | LibreOffice on various Linux systems