Keep formatting when referencing a string

[RogerGiudici]

I'd like to have the formatting of a text string moved along with its reference. I'd like to write a UDF that either sets the Characters property of the destination cell to match that of the original, or use the UDF in the conditional formatting for the cell. Third choice would be to write a function that sets the contents of a defined cell to the value and formatting of the source cell (i.e., do a copy and paste form the source cell to the destination cell)

 

[Tom Urtis]

Your question is rather vague. UDFs being formulas cannot themselves return formatted rssults. If you want to use a UDF with Conditional Formatting (or even if you don't), Conditional Formatting cannot format individual characters. What I don't understand is, if you want the same formatting in the original cell as in its destination cell, why not just copy and paste. Your situation should be explained a little more thoroughly, with an example of exactly what is in one cell, what it looks like format-wise, what you want to do and what your expected results are.

 

[RogerGiudici]

I have a worksheet that contains a table of information (let's call this sheet ItemDescription) about a set of objects. I need to produce a set of detail sheets on a user selected set of rows. When an attribute for a row is updated, the corresponding element on the detail sheet needs to be updated. The text in cell updated by the user contains formatting, such as text in blue to indicate changes. Right now I have a formula that looks like =index(ItemList, LineNumber,ColumnNumber) where ItemList is a named range fo rteh list, LIneNumber is teh calculated line number of eth item slected by teh user, and ColumnNumber is the number of the column that contains teh desired attribute. This brings forward the value of the cell but not its formatting. I'd like to create a UDF such as CopyFormattedText() that brings formward both the value and the formatting. A copy paste requires manual work by the user to move the data. My workbook only requires that they fill in a field in the list the specifies the record is to be insluded in teh summary report and that a detail report is to be created.