Formatting data in an already existing macro

[DPCpresto]

I am trying without success to insert into an already existing macro some code that would format data. What I need is code that:

Looks in all the text data within Column C (which can vary in length from day to day)
If the text in Col C equals "ABC", then make it unbold (ie: Font.Bold=false)
If the text in Col C equals "XWZ", then make the text color RED (ie: RGB 255.0.0)
after doing that, return to A1.

Thanks for the help.
Xman