Beklager. Denne artikkelen er ikke tilgjengelig på språket ditt.

Understand data at a glance with conditional formatting

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Sometimes it’s hard to read and interpret data by scanning rows and rows of information. But you can use conditional formatting to make certain data stand out, helping you to analyze data, and to identify patterns and trends.


After completing this course you will be able to:

  • Make data stand out by applying conditional formatting to cells.

  • Decide which type of conditional formatting to apply.

  • Clear conditional formatting from cells.

  • Make your own conditional formatting rules.

Download this course

Offline version (30 MB)


We’re sorry, the practice session is not available.

Quick reference card

See the quick reference card for a brief, printable reminder of the key points in this course.

See more courses on Microsoft Office Training.

Del Facebook Facebook Twitter Twitter E-post E-post

Var denne informasjonen nyttig?

Flott! Har du andre tilbakemeldinger?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingen!