Lists - Highlight your data with conditional formatting Video

00:01:23
3 views

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 video is part of the following courses

0 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