MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Serban on October 24, 2001 7:24 AM

How can I filter a list not by the content of the cells but by the font attributes?

Posted by Don C on October 24, 2001 7:47 AM


Given that this entire board is dedicated to Excel, a subject line of "Excel" doesn't give much help identifying your problem. Being more specific will help draw attention from those who might know the answer to your problem.

BTW, so far as I know, there is no way to filter by characteristics.

Posted by Thomas Lawton on October 24, 2001 8:08 AM

I think VBA is probably the only way. Examples :-

Sub Only_Hide_Bold_Cells()
Dim cell As Range
Selection.EntireRow.Hidden = False
For Each cell In Selection
If cell.Font.FontStyle = "Bold" Then cell.EntireRow.Hidden = True
End Sub

Sub Show_All_Cells()
Selection.EntireRow.Hidden = False
End Sub