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 402 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
AOO 4.1.5 Build 9789 on Mac OS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3470
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 29 guests