Excel Formatting

[rjribbit]

In Excel 2016 is there any way to put multiple data item's into 1 cell and format them differently or do you have to put the data into separate cells if you want to format each one differently?

 

[Rick Rothstein]

In Excel 2016 is there any way to put multiple data item's into 1 cell and format them differently or do you have to put the data into separate cells if you want to format each one differently?

You cannot do that with formulas, but there is a way to do it using VB event code. If you describe the what you want to format, tell us where to get it from and tell us how to format each part, someone here will create (and tell you how to implement) the code for you.

 

[rjribbit]

Thanks Rick: Here's a copy of the data base I'm using. The columns (with any data) are A, E, F, G and H.

Adult おとな 大人 1 Big 1 Person 1.1 Alone ひとり 一人 1 One 1 Person 1.2 American アメリカ人 アメリカ人 1 America 1 Person 1.3 Artificial じんこう 人工 1 Person 1 Construction 1.4 <colgroup><col><col span="3"><col><col><col><col></colgroup><tbody> </tbody>
Here's what one side of a card should look like (the "1." is NOT included).

<tbody>
</tbody>

おとな 大人 <msreadoutspan class="msreadout-line-highlight msreadout-inactive-highlight" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">1</msreadoutspan><msreadoutspan class="msreadout-line-highlight msreadout-inactive-highlight" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"> Big 2 Person</msreadoutspan> <tbody style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image: none; background-origin: padding-box; background-position-x: 0%; background-position-y: 0%; background-repeat: repeat; background-size: auto; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: 400; line-height: normal; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;"> </tbody> <strike style="background-position: 0% 0%; font: 400 13px Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; margin: 0px; padding: 0px; text-align: left; background-image: none; text-transform: none; text-indent: 0px; letter-spacing: normal; text-decoration: line-through; background-repeat: repeat; background-attachment: scroll; word-spacing: 0px; white-space: normal; orphans: 2; font-size-adjust: none; font-stretch: normal; background-clip: border-box; background-origin: padding-box; background-size: auto; -webkit-text-stroke-width: 0px;"></strike> <colgroup><col></colgroup><tbody> </tbody> <strike></strike> <colgroup><col></colgroup><tbody> </tbody> <colgroup><col width="96" style="width:72pt" span="3"> </colgroup><tbody> </tbody> <tbody> </tbody> <colgroup><col width="96" style="width:72pt" span="3"> </colgroup><tbody> </tbody> <tbody> </tbody> <colgroup><col width="96" style="width:72pt" span="3"> </colgroup><tbody> </tbody>

<colgroup><col width="96" style="width:72pt"> </colgroup><tbody>
</tbody>

<strike></strike>