Filter by font color, cell color, or icon sets

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

You can quickly filter data based on visual criteria, such as font color, cell color, or icon sets. And you can filter whether you have formatted cells, applied cell styles, or used conditional formatting.

  1. In a range of cells or a table column, click a cell that contains the cell color, font color, or icon that you want to filter by.

  2. On the Standard toolbar, click Filter Knappen Filter, standardværktøjslinjen .

  3. Click the arrow Pilen Autofilter in the column that contains the content that you want to filter.

  4. Under Filter, in the By color pop-up menu, select Cell Color, Font Color, or Cell Icon, and then click a color.

See also

Highlight data points with conditional formatting

About filtering

Filter a list of data

Apply, create, or remove a cell style

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!