1. Home
  2. Training Library
  3. Additional Resource Videos

Conditional Formatting

Developed with
QA
Start course
Overview
Difficulty
Beginner
Duration
33m
Students
264
Ratings
4.8/5
starstarstarstarstar-half
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
26913
Labs
122
Courses
1277
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.