Icon Sets in Conditional Formatting can be used to visualize values in a range of cells. To Apply Conditional Formatting for Icon Sets, Select the range of cells then go to Conditional Formatting and Select Icon Sets.
For more real time example of conditional formatting, check the below link :
• Excel 2010 : How to color entire row ...