LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default Format Bold - Only Part of a Function

I've searched this group, and found some discussion saying that this
cannot be done - but those are 10 year old answers.

What I want to do is create a sheet that looks like and functions like
a report by concatenating data from a different sheet. I can do the
concatenation easily - and if I needed conditional formatting, I know
how to do that - but what I want to do is have the concatenation
format some pieces of the function differently - to highlight the
title and some information that has been altered.

The formula looks like this:
=CONCATENATE(SLWInput!E3,B1,SLWInput!G3,B1,B1,SLWI nput!I3,
IF(SLWInput!K3"<none",CONCATENATE(B1,B1,"Busines s Rules",B1,SLWInput!
K3),""),
IF(SLWInput!M3"<none",CONCATENATE(B1,B1,"Authori tative
Documents",B1,SLWInput!M3),""),IF(SLWInput!
N3"<none",CONCATENATE(B1,B1,N3),""))

The most important thing would be to able to be able to bold the value
returned from "SLWInput!E3" - this wasn't possible in 1998, but is it
possible now through a function - or a user created function?
 
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 Format a Nested Function (Bold) GabrielN Excel Discussion (Misc queries) 2 May 22nd 08 05:45 PM
how do i make one part of my formula bold and the other normal? niquey Excel Worksheet Functions 6 March 27th 06 03:22 PM
bold part of cell unavailable at time DrB Excel Worksheet Functions 3 January 15th 06 09:04 PM
Fomatting part of a formula to be Bold font KimberlyC Excel Worksheet Functions 7 May 6th 05 02:18 AM
Bold part of formula results Rita Palazzi Excel Discussion (Misc queries) 4 December 16th 04 07:51 PM


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

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

About Us

"It's about Microsoft Excel"