Excel Formatting

R

rjribbit

New Member
Joined
Dec 1, 2015
Messages
4
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?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
rjribbit said:
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?
Click to expand...
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.
 
Upvote 0
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.
[TABLE="width: 743"]
<tbody>[TR]
[TD][TABLE="width: 761"]
<colgroup><col><col span="3"><col><col><col><col></colgroup><tbody>[TR]
[TD]Adult[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]おとな[/TD]
[TD]大人[/TD]
[TD]1 Big 1 Person[/TD]
[TD]1.1[/TD]
[/TR]
[TR]
[TD]Alone[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ひとり[/TD]
[TD]一人[/TD]
[TD]1 One 1 Person[/TD]
[TD]1.2[/TD]
[/TR]
[TR]
[TD]American[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]アメリカ人[/TD]
[TD]アメリカ人[/TD]
[TD]1 America 1 Person[/TD]
[TD]1.3[/TD]
[/TR]
[TR]
[TD]Artificial[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]じんこう[/TD]
[TD]人工[/TD]
[TD]1 Person 1 Construction[/TD]
[TD]1.4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Here's what one side of a card should look like (the "1." is NOT included).[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 96"]
<colgroup><col width="96" style="width:72pt"> </colgroup><tbody>[TR]
[TD="width: 96, bgcolor: transparent"][TABLE="width: 288"]
<colgroup><col width="96" style="width:72pt" span="3"> </colgroup><tbody>[TR]
[TD="width: 96, bgcolor: transparent"][TABLE="width: 288"]
<colgroup><col width="96" style="width:72pt" span="3"> </colgroup><tbody>[TR]
[TD="width: 96, bgcolor: transparent"][TABLE="width: 288"]
<colgroup><col width="96" style="width:72pt" span="3"> </colgroup><tbody>[TR]
[TD="width: 96, bgcolor: transparent"][TABLE="width: 150"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
  1. [TABLE="width: 207"]
    <colgroup><col></colgroup><tbody>[TR]
    [TD][TABLE="width: 207"]
    <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;">[TR="bgcolor: transparent"]
    [TD] おとな[/TD]
    [/TR]
    [TR="bgcolor: transparent"]
    [TD] 大人[/TD]
    [/TR]
    [TR="bgcolor: transparent"]
    [TD]<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>[/TD]
    [/TR]
    </tbody>[/TABLE]
    <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>[/TD]
    [/TR]
    [TR]
    [TD]
    [/TD]
    [/TR]
    [TR]
    [TD][/TD]
    [/TR]
    </tbody>[/TABLE]
    <strike></strike>
[/TD]
[/TR]
[TR]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 96, bgcolor: transparent"][/TD]
[TD="width: 96, bgcolor: transparent, align: left"]
clip_image002.png
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 96, bgcolor: transparent"][/TD]
[TD="width: 96, bgcolor: transparent, align: left"]
clip_image002.png

<tbody>
[TD="width: 96, bgcolor: transparent"][/TD]

</tbody>
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="width: 96, bgcolor: transparent"][/TD]
[TD="width: 96, bgcolor: transparent, align: left"]
clip_image002.png

<tbody>
[TD="width: 96, bgcolor: transparent"][/TD]

</tbody>
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
help with a search function
Replies
8
Views
85
Cubist
Cubist
J
  • Question Question
Conditional formatting of single column of pivot table
Replies
8
Views
342
Peter_SSs
Peter_SSs
S
  • Question Question
Conditional Formatting Formula Help
Replies
3
Views
353
etaf
etaf
J
  • Question Question
Help with Sumifs formula involving dates
Replies
5
Views
84
Joe4
Joe4
T
  • Question Question
Switch() or better alternative?
Replies
3
Views
61
RoryA
RoryA

Forum statistics

Threads
1,224,823
Messages
6,181,185
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top