• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter Bold Text in Excel 2007

gaggarvaibhav

New Member
Dear Members,


I want to filter only bold text in excel but not by using VBA. Is there is any formula or any other way? Please suggest me.


Thanks & Regards,


Vaibhav
 
Hi Vaibhav,


Assuming your Bold/Normal Font are in Column A and Column B is blank


* Name Manager > New

* Name : Bold_cell

* Refers to : =GET.CELL(20,OFFSET(INDIRECT("A1"),ROW()-1,0))

* Now in B1 Write Formula as =Bold_cell


* Drag down and apply filter in Column B.


Regards,

Deb
 
Back
Top