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?

It is still not possible, as a function cannot return a format, only a
value.

You can't even do it manually while there is a formula in the cell,
though if you fixed the values then you would be able to.

You can do it with a macro, though only on the fixed values.

Maybe you could arrange that the formula is split into adjacent cells,
then one cell could have Bold applied to it.

This probably doesn't help you in your quest ...

Pete

On Aug 12, 4:43*pm, wrote:
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?

On Aug 12, 12:18*pm, Pete_UK wrote:
It is still not possible, as a function cannot return a format, only a
value.

You can't even do it manually while there is a formula in the cell,
though if you fixed the values then you would be able to.

You can do it with a macro, though only on the fixed values.

Maybe you could arrange that the formula is split into adjacent cells,
then one cell could have Bold applied to it.

This probably doesn't help you in your quest ...

Pete

On Aug 12, 4:43*pm, wrote:

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?

It does help in the sense that I can end my quest - if Excel cannot do
it, than I'll do a mail merge type report in Word.

Okay, thanks for feeding back.

Pete

On Aug 12, 7:52*pm, wrote:

It does help in the sense that I can end my quest - if Excel cannot do
it, than I'll do a mail merge type report in Word.