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.