Change font color of a string that is a variable

I want to change the font color of a string that is a variable.
This is my attempt, which generates an "Invalid qualifier" error.
The "sActual" is invalid. (Probably because its a string).

Please Login or Register  to view this content.

I was able to change the font color via, Sh4Cell.Font.Color = "value", but that did not allow the attribute to stay with the value stored in sActual.

How can I set the font attribute and maintain that attribute as I paste the value (sActual) in other areas of the workbook?

Macro sample:

Please Login or Register  to view this content.

Any hints, tips or examples are appreciated.

Only text in a cell can have an associated font color attribute. A really simple way to do this is to use a cell to store the value of sActual, instead of a String variable. Instead of declaring sActual as a String, declare it as a range, then assign it some cell. The cell could even be on a hidden worksheet. In my example, I assume a new worksheet called Scratch.

Please Login or Register  to view this content.

Then I think the rest of your code will work as is.

I will give this a try in the morning.
Thank you.

Resolved via another method.
http://www.excelforum.com/excel-prog...ml#post2648442