How do I keep formats (eg.color) when making a relative reference
 

When you have text in a cell (eg. A1 has "Correct") that is colored green and
in another cell (eg. b1) you have a formula refering to that cell "(eg.
"=A1") how do you get the formula to keep the format of the referenced cell.

It doesn't. YOu have to pretty much format each cell as needed. YOu could
use Conditional Formatting in the formula cell, setting it to turn green if
the cell is "Correct".

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"I hope you can help" <I hope you can wrote
in message ...
When you have text in a cell (eg. A1 has "Correct") that is colored green
and
in another cell (eg. b1) you have a formula refering to that cell "(eg.
"=A1") how do you get the formula to keep the format of the referenced
cell.

Conditional formating will work but what I was really doing is concatenating
various cells together and trying to keep all the unique colored text. (eg.
Cell B1 would be =A1&A2&A3 and A1 would have red text, A2 would have green
text and A3 would have blue text).

It looks like I will have to build a macro.



"Earl Kiosterud" wrote:

It doesn't. YOu have to pretty much format each cell as needed. YOu could
use Conditional Formatting in the formula cell, setting it to turn green if
the cell is "Correct".

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"I hope you can help" <I hope you can wrote
in message ...
When you have text in a cell (eg. A1 has "Correct") that is colored green
and
in another cell (eg. b1) you have a formula refering to that cell "(eg.
"=A1") how do you get the formula to keep the format of the referenced
cell.