Maintain mutliple original formats in a formula result

[Guest]

Hello,

I have data like in this forrmat, but vastly expanded in all columns

A B
Location Comment
--------- -----------
(London) "Very Good"
(Sydney) "No Disabled access"
(Dallas) "Guest Speaker poor"

My Location column is set as subscript font.
My Comment column has the font colour conditionally formatted based on an
external reference that shows the positive or negative nature of the comment
on a graded scale

I have produced stats of types of comments, and need to illustrate it with a
few examples.

I know I can use =B1&" "&A1
To give me the result "Very Good" (London)

But then the colour and subscript font is lost, as I have over 500 coments
to use, changing each one individually by copying the formula result as text
and formatting each cell to get the desired effect would take far too long to
be practical.

Is there a way I can maintain the font formatting in my formula result easily?

Happy New Year, and thanks for any help you can provide, and even for the
"thinking time" spent.

Regards

KeLee

 

[David McRitchie]

Hi Ke,
If I understand you correctly, you want the same Conditional Formatting in you
generated Column C as you are using in Column B.

Depending on how your formulas are written you might be able to copy the
format from the entire column B and edit, paste special, formulas to column C.

More on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

 

[David McRitchie]

meant edit, paste special, *formats* not formulas