| DAL4 A1.2 |
- [Instructor] 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.
QA: A world-leading tech and digital skills organisation
We help many of the world’s leading companies to build their tech and digital capabilities via our range of world class training courses, reskilling bootcamps, work-based learning programmes and Apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.