Here is a way to filter a list by the font of certain entries:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
I have a list of contestants where the names are in Arial 12 pt. bold, and the addresses are in Calibri 11 pt. not bold. I want to filter the list so I can just see the names:
There is no filtering option in the standard Filter process in Excel (located on the Data tab in the Sort & Filter group) to filter by font, so we are going to have to do this in multiple steps.
First, I will highlight the list, excluding the header, and use the keyboard shortcut Ctrl F to open the Find dialog box, and click on Options:
Click on Format and then enter the specifics about the format by which you want to filter:
Click OK. Now click on Find All, then use the keyboard shortcut Ctrl A to select all of the cells that meet that criteria:
You will see that Excel has selected each cell that meets the format you defined. Now, close the Find box, and choose a color to highlight the selected cells:
At this point, you can now activate the Filter option, and then choose to filter by color:
And you now have a filtered list by the specified format:
Piece of cake (hmmm, that makes me hungry)!