Lists - Highlight your data with conditional formatting Tutorial

Uncover the power of conditional formatting in 'Highlight Your Data with Conditional Formatting'. This engaging tutorial guides you through making your data visually intuitive and collaborative. Learn to apply rules for clear status tracking and ensure everyone on your team can see the vital information at a glance. Discover how to enhance your spreadsheets today!

01:24
189 views

Available in Microsoft365

00:00:06

Some of these trips have already been approved by management,

00:00:09

while others are still pending.

00:00:11

To make their status easier to see immediately,

00:00:13

we will apply conditional formatting.

00:00:17

From the View menu choose Format view,

00:00:19

then select conditional formatting.

00:00:21

The ellipsis beside the rule list lets you edit an existing rule or add a new one.

00:00:27

Every rule is defined by a condition.

00:00:30

For example,

00:00:31

if the approval field equals yes,

00:00:34

the entire row will appear in green.

00:00:37

The effect is visible immediately,

00:00:39

no extra confirmation is required.

00:00:42

Remember that any formatting you apply here is

00:00:44

instantly visible to everyone who shares this view.

00:00:48

You can also create formatting that targets a single column,

00:00:52

depending on the data type chosen.

00:00:55

Select the column you want,

00:00:56

open settings,

00:00:58

and click format this column.

00:01:00

For instance,

00:01:02

you might highlight the date column according to conditions you specify.

00:01:07

When requirements change or mistakes occur,

00:01:10

delete any obsolete rules.

00:01:12

You can remove a single rule by opening the ellipsis menu

00:01:16

and managing it individually or disable all conditional

00:01:20

formatting at once with a dedicated button.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

169 Views

Microsoft Lists Video Training - Advanced

Discover the full potential of Microsoft Lists thanks to advanced features for structuring and automate your projects.

ALL COURSES