Changing the Appearance od Data Based on Its Value

To change the apperance of data:

• first select what you want to change the appearance. 
• Then go to the home tab. 
• In the styles group click on conditional formatting. 
• Then click on any of the choices and you can pick which appearance you want for the group of data that you have and what the data's value is based on.