Text box to determine internal format color

[Guest]

I have a spreadsheet with multiple cells and text boxes in some of the cells.
I want to be able to change the internal format of the cell based on the
information contained in the text box.

Also, is there a way to wrap the text box around the data in the cell like
the way Word can?

Any assistance would be appreciated.
oldybutgoody

 

[Guest]

I was hoping that someone knew how to do this... Any help would be appreciated.