this is one of my first brush ups with VBA(and excel, for that matter), so I don't know much about the language.
nycase, I'm supposed to write a macro that will check the text in a certain cell to see if there are any specific words(which I define), and turn them Red.

I've thought of a way to do this, but I need to be able to define which a place within a cell. ex. if <> is a cell, then <Hello world, how are you today> I would need to say "from space 6 onwards check if...., then from space 13 onwards, check if....." etc.

can anyone explain how to do this? thanks alot.

if you know a good way of making this macro, please tell me that as well ^_~