Hi Sandy and welcome to the forum,

You want to learn about "Conditional Formatting". Watch

http://office.microsoft.com/en-us/vi...102500798.aspx