Filter Bold Text in Excel 2007

[gaggarvaibhav]

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

 

[Debraj]

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

 

[Raja Kamarthi]

@Debraj Roy


Amazed to see this stuff. Absolutely brilliant


Regards,

Raja

 

[Debraj]

Thanks Raja..