How do I filter on bold, struck through or italic text in Excel 2007?

Question

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?

Solution

Not exactly - you can only filter an Excel column based on its value, its cell colour, or its font colour.

However, using Find and Replace, you can replace all formatting of a certain type with a filterable version: e.g. replacing all struck through cells with cells with red text. You can then filter on this basis.

Comments

[ᔕᖺᘎᕊ]

Macro solution

[Searush]

Also you can achieve it by using Excel macros (VBA)

[SinisterBeard]

@Searas - Absolutely.