I get this query all the time. People have huge data sets and someone in their team has highlighted some records by formatting it in bold font. Now, you are the one who gets this data, and you have to filter all these records that have a bold formatting. For example, suppose you have the data set as shown below, and you want to filter all the cells that have been formatted in bold font.

Let’s face it. There is no straightforward way of doing it. You cannot simply use an Excel filter to get all the bold cells. Solidworks viewer for mac. But that doesn’t mean you have to waste hours and do it manually. In this tutorial, I will show you three ways to filter cells with bold font formatting in Excel.

In the popped out Replace Format dialog, choose one color you like under the Fill tab, see screenshot: 6. Then click OK to go back to the Find and Replace dialog, click Replace All button to replace the color at once, and a prompt box will pop out to remind you the number of the replacements, see screenshot: 7. May 5, 2015 - Started by W123456, May 05 2015 02:42 AM. You can see how to find and replace the formatting of cells in the video lesson. For Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac.

This Tutorial Covers: • • • Method 1 – Filter Bold Cells Using Find and Replace can be used to find specific text in the worksheet, as well as a specific format (such as cell color, font color, bold font, font color). The idea is to find the bold font formatting in the worksheet and convert it into something that can be easily filtered (Hint: Cell color can be used as a filter). Here are the steps filter cells with bold text format: • Select the entire data set. • Go to the Home tab. • In the Editing group, click on the Find and Select drop down. • Click on Replace.

( Keyboard shortcut: Control + H) • In the Find and Replace dialog box, click on the Options button. • In the Find what section, go to the Format drop-down and select ‘Choose Format From Cell’. • Select any cell which has the text in bold font format. • In the ‘Replace with:’ section, go to Format drop-down and click on ‘Choose Format From Cell’ option.

• In the Replace Format dialog box, select the Fill Tab and select any color and click OK (make sure it’s a color that is not there already in your worksheet cells). • Click on Replace All.

This will color all the cells that have the text with bold font formatting. In the above steps, we have converted the bold text format into a format that is recognized as a filter criterion by Excel. Now to filter these cells, here are the steps: • Select the entire data set. • Go to the Data tab. • Click on the Filter icon (Key Board Shortcut: Control + Shift + L) • For the column that you want to filter, click on the filter icon (the downward pointing arrow in the cell). • In the drop-down, go to the ‘Filter by Color’ option and select the color you applied to cells with text in bold font format. This will automatically filter all those cells that have bold font formatting in it.