Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Is it possible to format a cell w/ 2 font sizes by formula?

One of my users is looking to setup a cell by formula (ie. =A1&B1) where A1
would have a 10 point font size and B1 would have a 6 point size?

We can setup 2 font sizes on a manually entered data cell, but can't seem to
find a way to do it w/ a formula for multiple calculated cells.

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Is it possible to format a cell w/ 2 font sizes by formula?

Formulas don't support this kind of formatting.

The Beef wrote:

One of my users is looking to setup a cell by formula (ie. =A1&B1) where A1
would have a 10 point font size and B1 would have a 6 point size?

We can setup 2 font sizes on a manually entered data cell, but can't seem to
find a way to do it w/ a formula for multiple calculated cells.

Thanks.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Is it possible to format a cell w/ 2 font sizes by formula?

Not possible by formula.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 12:05:02 -0700, The Beef <The
wrote:

One of my users is looking to setup a cell by formula (ie. =A1&B1) where A1
would have a 10 point font size and B1 would have a 6 point size?

We can setup 2 font sizes on a manually entered data cell, but can't seem to
find a way to do it w/ a formula for multiple calculated cells.

Thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sent for cell: font size=7,text format in VBA netx Excel Discussion (Misc queries) 1 August 8th 05 06:50 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Mixing Font Sizes In A Cell Formula Minitman Excel Worksheet Functions 2 November 11th 04 03:40 PM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"