Highlight data points with conditional formatting

Some of the content in this topic may not be applicable to some languages.


Conditional formatting makes it easier for you to notice interesting cells, to see unexpected values, and to visualize data. You apply conditional formatting to data by using color or icons. You can quickly find the highest or lowest results, or identify duplicate values.


  1. Select the data that you want to format.

    Markerede data

  2. On the Home tab, under Format, click Conditional Formatting, and then click Color Scales.

    Menu for betinget formatering med undermenu

  3. Click one of the color scale icons.

    Trefarvet skala med rød, grøn og blå

    In a three-color scale, the top color represents larger values, the middle color represents medium values, and the bottom color represents smaller values. In this table, the cells with the largest values have the strongest red.

  4. Experiment with conditional formatting. On the Home tab, under Format, click Conditional Formatting, and explore the available options.

    Menu for betinget formatering


  • Cells can have more than one conditional format applied.

  • You can copy these effects from one location to another. Select the cells that have the formatting that you want, and then, on the Standard toolbar, click Format  Knappen Formatér , and then click or select the location that you want to apply it to.

  • To clear conditional formatting, select the formatted cells. On the Home tab, under Format, click Conditional Formatting. Point to Clear Rules, and then click Clear Rules from Selected Cells.

See also

Highlight patterns and trends with conditional formatting

Use data bars, color scales, and icon sets to highlight data

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!