Use spreadsheet formatting in containers

Hey @MWight -- thanks for posting! This is not something we natively support, however, you could try a couple things. The first idea that comes to mind is setting one of your container cells as the default style shape. This will apply across your smart container to all other cells. 

The next idea I have is utilizing conditional formatting. This would allow you to utilize the data to format the text in whatever way you’d like dependent on the data. 

Hope this helps!

Neither of these work. 

I see nothing in smart containers that address text formatting.

Conditional formatting doesn’t allow you to test the format of the source text nor does it allow you to set the format of the text in the shape.

Hey @MWight -- thank you for the response! So, to format the text in your Smart Containers, you can adjust it like with any other text. You can highlight or select the cell you’d like to format and adjust the text in the toolbar in the top. From there, you can set that cell as the default format and it will adjust all the other cells to match. 

If this doesn’t work, happy to help with a different solution. Would you mind to send me a bit more info on what exactly you’re trying to accomplish?

Thanks so much for all your help and patience!

I have a spreadsheet with textual data. The text is colour coded.  Some is red, some black, some orange and so on.  I want this formatting to show up in my containers automatically.  When I import the data, I see the colours, in the data linking pane.  But the formatting does not transfer to the container.  I want to find a way to automatically (i.e. error free and quickly) match the container text colours to the original spreadsheet text colours.