image
Conditional Formatting
Start course
Difficulty
Beginner
Duration
33m
Students
362
Ratings
4.7/5
Description

Additional information

Transcript

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.

About the Author
Students
44173
Labs
168
Courses
1754
Learning Paths
45

A world-leading tech and digital skills organization, 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 programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.