1. Select cells in the data set
2. *Click: Home->Styles->Conditional Formatting->choose between:* a. Data Bars
b. Color Scales (will display the selected spectrum of colors based on cell values) c. Icon Sets
3. Custom formats can be chosen from within each visualization type (customer color variations, borders etc.)