Conditional Formatting

Conditional formatting can be used to visually show the highest or lowest items graphically by using such a feature as a Data Bar. Here, the largest figure is the widest line. I can also highlight cells that are highest items in the list, or I can indicate highest and lowest items by using features such as Icon Sets. We can also create Rules for conditional formats using potentially a Formula to indicate whether something is above or below a specific amount under relevant Formats, if this matches. If the value is lower, then the Format doesn't display.