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

Conditional Formatting

Developed with
QA
Start course
Overview
Difficulty
Beginner
Duration
33m
Students
229
Ratings
4.7/5
starstarstarstarstar-half
Description

Additional information

Transcript

- [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.

About the Author
Avatar
QA
Training Provider
Students
8839
Labs
31
Courses
54
Learning Paths
33

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.