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?

Answer 1

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.

Answer 2

Module solution for italics (adapted from here)

Function IsItalics(rCell As Range)
IsItalics = rCell.Font.Italic
End Function

Then, IsItalics(cell address)