excel - bringing cell formatting along with cell = 1

[Melissabrooks]

Hi
I have a cell (b5) that has some formatting such as font and color changes, and I want to make a cell on another worksheet equal that cell using, say, =b5 as an example.
Is it possible to get the formatting to follow so that what ever the source cell contains for color and formatting will display along with the value in the destination cell?

Thank you,
mb

 

[Corgano]

Since the foluma is static (will only ever equal B5) you can just copy the source cell, right click on the destination cell and choose "Paste Special" and the choose "Formats.

 

[Melissabrooks]

thank you,

Problem is that B5 may be changed by the user, and they want the formatting changes they make to B5 to show up in the destination cell dynamically, so that they don't have to use the copy/paste special function.

mb

 

[KenWright]

Not unless the formatting on the source cell is done via Conditional formatting, in which case you just apply the same CF to the destination cell. Failing that, VBA is your only option for this.

Regards
Ken..................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Melissabrooks]

I'm on to some vbe code that seems to be a good start, I'll update if it works!

Thanks guys!

mb

 

[KenWright]

Just in case it is of any use, if you don't have any other data reliant on the destination cell, then you can copy the source cell, pick the destination cell, hold down SHIFT and choose Edit / Paste Picture Link. This is a picture only, but will update with colours / formats / numbers etc as the source cell is changed.

Regards
Ken...................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Melissabrooks]

Nice! This may just be the simplist solution.
And all this time I thought James was the man, and it turned out to be Ken!

Thank you,

mb

 

[Bowers74]

Ken, EXCELLENT answer!!!

And . . . even if there are

any other data reliant on the destination cell

Then Melissa could change the formulae for these cells to be based on cell "B5" (example cell).



Peace!!

Mike

Didn't get the answers that you wanted? Then . . . Click Here

 

[KenWright]

Cheers Mike

If you want to make it bigger btw, eg spread this single cell across say 4 cells (2x2) which gives the appearance of merged cells with a bigger font, then click on the picture, hold down the ALT key and drag it out. Holding down the ALT key will ensure that the image scales up exactly with the cell sizes. This can also be used with any other picture / image / VBA control etc, and makes for a nice neat looking solution that appears to actually be in the cell itself as opposed to floating around on top of it.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[KenWright]

[Blushes]
Why thank you Melissa, you are too kind
[/Blushes]

Regards
Ken..............



----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------