Ask Your Question
0

I use a 3 page sheet for my work. Page 3 is a summary of 1 & 2. To avoid entering the data twice, I use "=cell". Can I automatically copy font colours or background highlighted colours.

asked 2019-08-19 07:49:49 +0200

twinsdad gravatar image

I use a 3 sheet doc for my work. Page 3 is a summary of 1 & 2. To avoid entering the data twice, I use "=cell" to copy to sheet 3. Can I automatically copy font colours or background highlighted colours.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-08-19 12:20:35 +0200

Opaque gravatar image

updated 2019-08-19 13:51:47 +0200

Hello,

No, you can't using formulas. In fact you even don't copy anything using something like =A1. This is a reference to (the content of) cell A1, just like a hyperklink on the web doesn't copy the content but referreing to some content on another site, =A1 does point to the content of cell A1 and does not copy its conten to the cell containing the formula. The content of a referring cell is a formula.

There are no formulas referring to the format of another cell, thus you can't do what you want to achieve using a formula. To put it other way round: You would need to write a macro to peform a copy of the format of another cell.

edit flag offensive delete link more

Comments

Thanks Opaque. You say "you can't using formulas" is there another way to do It? Thanks twinsdad

twinsdad gravatar imagetwinsdad ( 2019-08-19 15:25:27 +0200 )edit

As stated in my answer: You would need to write a macro to peform a copy of the format of another cell - but from my perspective that would be a disproportionate effort. In general I'd do such such things using Conditional Formatting, since in general you have some rules in mind to format the original cell in a certain way and thus apply a manual format and the same formatting rule can be applied to the overview cell (referencing cell).

Opaque gravatar imageOpaque ( 2019-08-19 15:54:30 +0200 )edit

Thank you very much

twinsdad gravatar imagetwinsdad ( 2019-08-20 15:20:35 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-19 07:49:49 +0200

Seen: 32 times

Last updated: Aug 19