Log In
Register
Home
August 14, 2019
Offline
Is there anyway to keep the formatting of a cell that is referenced in a text box? On the attachment, I've added a text box to pull in what is in the corresponding time frames tabs to show the $ difference for each 4,12,26,&52wks. The formatting is green/red on the tab, but the text box doesn't keep the formatting. Is there away to show this as green/red on the dashboard?
See Answer
VIP
Trusted Members
June 25, 2016
Offline
Hi Cara
You can copying the required cell and then pasting as linked picture.
Cheers
Sunny
August 14, 2019
Offline
Hi Sunny,
It seems like it doesn't keep the formatting when you use the slicer then because it is pasted as a picture and not linked to the formula. I also want to keep the text box next to the pivot chart. I can only do what you mentioned by pasting it into a cell. Are you able to update and repost the spreadsheet I have attached with what you are referencing? Maybe I'm missing something.
Thanks!
VIP
Trusted Members
June 25, 2016
Offline
Hi Cara
When I recreated the formula into another cell and copy paste link the cell, it seems to work.
You can delete the old formula in F1 but do not delete the column otherwise it will fail.
Frankly I have no idea why it is not working properly. I suspect there could be some kind of corruption to the file.
You may want to recreate a new file and try again.
Trusted Members
December 20, 2019
Offline
it doesnt seem possible for a text box to carry over formatting from what i can see, however you could put the formula in a cell behind the bar graph and make the background transparent, seems to show a simular effect?
The fomula on each sheet needed up dating to include the sheet names as it was referencing a pivot table, but i gave it a quick test and seems to be working.
Purfleet
Answers Post
1 Guest(s)
