>I am wondering how you would set off a trigger based on only one column changing? Is this possible? I know you can set a trigger to run if there has been a delete, update or insert based on the table, but how would you narrow this down to one column having changed?

I haven't checked other responses, but take a look at UPDATE() function in BOL