I looked at the macro code that I had, and it looked pretty similar to what you posted, except the line referring to font color just wasn't there. I popped that in there and now the macro works as I desired. Just wondering why that step wasn't recorded in automatically. I tried recording it several times, always with the same result. Anyway, now I have what I wanted, thank you.

Macros won't record mouse movement or Icons on the Ribbon. You have to use the Font Dialogue Box to make your changes instead.

Okay, thanks for letting me know. I may have been clicking icons on the ribbon, that would explain the problem.

I had exactly the same problem. However, this did work in Office 2007. This looks like a MicroSoft bug as other options on the ribbon work. However, the font colour does not record unless you open the font window as indicated on this thread.