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

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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

J
  • Question Question
Conditional formatting of single column of pivot table
Replies
8
Views
233
Peter_SSs
Peter_SSs
S
  • Question Question
Conditional Formatting Formula Help
Replies
3
Views
350
etaf
etaf
W
  • Question Question
Conditional Format Bar Chart
Replies
1
Views
19
Sergius
S
L
  • Solved
VBA Replace All '/' in a sheet, except for formulas
Replies
4
Views
114
MARK858
MARK858
S
  • Question Question
How to Compare Multiple Scenarios Dynamically in Excel Without Displaying All Scenarios in One Table
Replies
0
Views
77
Shahar
S

Forum statistics

Threads
1,223,911
Messages
6,175,331
Members
452,636
Latest member
laura12345

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