software

Hello,

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

A B
Location Comment
--------- -----------
(London) quot;Very Goodquot;
(Sydney) quot;No Disabled accessquot;
(Dallas) quot;Guest Speaker poorquot;

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 =B1amp;quot; quot;amp;A1
To give me the result quot;Very Goodquot; (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
quot;thinking timequot; spent.

Regards

KeLee

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
www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;KeLeequot; gt; wrote in message ...
gt; Hello,
gt;
gt; I have data like in this forrmat, but vastly expanded in all columns
gt;
gt; A B
gt; Location Comment
gt; --------- -----------
gt; (London) quot;Very Goodquot;
gt; (Sydney) quot;No Disabled accessquot;
gt; (Dallas) quot;Guest Speaker poorquot;
gt;
gt; My Location column is set as subscript font.
gt; My Comment column has the font colour conditionally formatted based on an
gt; external reference that shows the positive or negative nature of the comment
gt; on a graded scale
gt;
gt; I have produced stats of types of comments, and need to illustrate it with a
gt; few examples.
gt;
gt; I know I can use =B1amp;quot; quot;amp;A1
gt; To give me the result quot;Very Goodquot; (London)
gt;
gt; But then the colour and subscript font is lost, as I have over 500 coments
gt; to use, changing each one individually by copying the formula result as text
gt; and formatting each cell to get the desired effect would take far too long to
gt; be practical.
gt;
gt; Is there a way I can maintain the font formatting in my formula result easily?
gt;
gt; Happy New Year, and thanks for any help you can provide, and even for the
gt; quot;thinking timequot; spent.
gt;
gt; Regards
gt;
gt; KeLee
meant edit, paste special, *formats* not formulas