Apply Conditional Formatting (from the Styles section on the ribbon's Home tab) to get color coding, icons, and integrated data-bar graphs (or a mix) on each cell. These visual clues provide an instant view of highest and lowest numbers in that column or row, even if it's unsorted.

Name:  Color code for visual clues.jpg
Views: 577
Size:  50.5 KB