Conditional formatting in excel 2010 based on value of another cell. Choose Conditional Formatting and select New Rule.