Excel 2003 has a function called Conditional Formatting which can do this for you rather easily. It's in the Formats menu. If you struggle with using it you will find Excel's Help entries on the function are comprehensive.

Good luck!