How to Select based on format ?

Hello Experts,

I have one column which has list of records (only character type) - I just want to Filter those records which are BOLD.

for instance:

Ram
Shayam
Tony
Guy
Julie
Sandy
Mandy

Result should be

Tony
Julie
Sandy

Because all three records are in BOLD.

Can somebody please tell me how to achieve this ?

Waiting for your reply

A

Excel does not offer a way to sort or filter on text formatting (bold, italic, etc.), nor any way to even detect it.

You can write your own user-defined function to do this:

Please Login or Register  to view this content.

This function will return TRUE if the referenced cell is bold, otherwise FALSE. If more than one cell is referenced, it looks at the cell in the upper-left corner of the range.

In Excel, hit ALT-F11. That opens the VBA development window. On the left you will see a hierarchy structure that includes the file you have open. Right-click on that file name, then Insert, then Module. You will see a new item under your file called Module1. Double click on it, and you will see a blank screen to the right. Then paste in the code above. Then you can close this window.

Then you can use the function

=IsBold(A1)

to return the boldness of the font in a second column, and filter on the second column.

Note that Excel will not refresh the value of this function if the boldness of the referenced cell changes; the function is reevaluated only if the value of the cell changes, and Excel does not consider a format change to be a change in value. So if you need to refresh the values, you have to manually reapply the function (e.g., F2, ENTER, then fill down).

Are you sure you're hitting ALT and F11 at the same time? If not, Excel will do nothing, or possibly create a new chart sheet.

You should see something like this

you can filter in excel 2007 by
copying the range you want to filter next to itself
then in the copied column
find format bold
replace with say xxxxxxxx
then filter that column on xxxxxxxx
or simply in the original
find what----- choose format select bold
replace -format - chose a cell colour say yellow background
all the bold cells will then have a yellow background
you can then filter by colour yellow