Are you sure you want a macro. Conditional Formatting feature will take care of your requirements.