Hi LookingGood,

From the little detail that you provide, it would seem that Excel's
Conditional Forma ( Menus | Format | Conditional Formatting...) option
would be appropriate

For more information see Debra Dalgleish at:

http://www.contextures.com/xlCondFormat01.html

If you need to automate this process, turn on the macro recorder while you
perform the operation manually. The resultant code may be edited to allow
for more general application.

If you experience problems with such editing, post back with the problematic
code.


---
Regards,
Norman


"LookingGood" wrote in message
...
How do u modify data in a cell with different color text thru VBA.
I want to append data with a different color to the existing cell.