In cell A1is the text Test and that text is bolded, underlined and red. What i want to know is, how can I keep the bold, underlining and font color i use a formula to bring A1 to a new cell. For example, if in cell B1 i put "=A1". When the value is brought over it is simply the word text but the text format didnt come though.
I want to know how to keep the values formatting when bringing it over from a formula. The formula I have is much lengthier than the example but hopefully it is the same process to keep the formatting Thanks!!
I want to know how to keep the values formatting when bringing it over from a formula. The formula I have is much lengthier than the example but hopefully it is the same process to keep the formatting Thanks!!