Transfer color from cell to cell

Discuss the spreadsheet application

Transfer color from cell to cell

Postby Hermann- » Tue Oct 03, 2017 4:57 pm

Hi,

I'd like to transfer a cells value (text or number), formula and color to a different cell in a different tab.
so in the target cell I put “ =[tab name][source cell] ” . The numbers and formula has been taken over into the new tab, but not the color. Is there a way how I could also achive that with a formula?

example (within the same tab). Cell 40 is the source cell and cell 36 / 37 the target
hWufAw.png
hWufAw.png (7.08 KiB) Viewed 184 times

I know that I could use a macro to do this and it actually works, but since I have many rows to cover, a macro takes too long for me to setup.

Thanks.
OpenOffice 4.1.3 on WIndows
Hermann-
 
Posts: 1
Joined: Tue Oct 03, 2017 4:19 pm

Re: transfer color from cell to cell

Postby MrProgrammer » Tue Oct 03, 2017 6:40 pm

Hi, and welcome to the forum.

Hermann- wrote:I'd like to transfer a cells value (text or number), formula and color to a different cell in a different tab.
[Solved] Copy style based on a cell

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
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3119
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: Yahoo [Bot] and 24 guests