#1   Report Post  
Pat
 
Posts: n/a
Default Filter on bold

Can anyone tell me if it is possible to filter only bold text in a list.

Thanks


  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default Filter on bold

Hi Pat

Excel can't do this but my EasyFilter add-in have a option to do this
You can find it here

http://www.rondebruin.nl/easyfilter.htm
at the bottom of the page : Beta version 2.1


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message ...
Can anyone tell me if it is possible to filter only bold text in a list.

Thanks




  #3   Report Post  
Pat
 
Posts: n/a
Default Filter on bold

Hello Ron,

Installed your beta version and i am getting an error: The header cell is
empty, or there is no empty row above your headers.

I cannot understand why the above message appears because on the EasyFilter
Sample DataBase it works fine. Any suggestions?

Pat



"Ron de Bruin" wrote in message
...
Hi Pat

Excel can't do this but my EasyFilter add-in have a option to do this
You can find it here

http://www.rondebruin.nl/easyfilter.htm
at the bottom of the page : Beta version 2.1


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message

...
Can anyone tell me if it is possible to filter only bold text in a list.

Thanks






  #4   Report Post  
Ron de Bruin
 
Posts: n/a
Default Filter on bold

Hi Pat

Do you have the same problem when you select all cells in the column
You can send me the workbook private if you want and I take a look at it tomorrow.

Bedtime for me now

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message ...
Hello Ron,

Installed your beta version and i am getting an error: The header cell is
empty, or there is no empty row above your headers.

I cannot understand why the above message appears because on the EasyFilter
Sample DataBase it works fine. Any suggestions?

Pat



"Ron de Bruin" wrote in message
...
Hi Pat

Excel can't do this but my EasyFilter add-in have a option to do this
You can find it here

http://www.rondebruin.nl/easyfilter.htm
at the bottom of the page : Beta version 2.1


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message

...
Can anyone tell me if it is possible to filter only bold text in a list.

Thanks








  #5   Report Post  
Pat
 
Posts: n/a
Default Filter on bold

On the test sheet I created there were a number of empty rows above the
column containing text. When I deleted all the empty rows the problem went
away.
Done a filter on cells containing bold text and it worked great.

Congratulations on a handy filtering tool.

Pat


"Ron de Bruin" wrote in message
...
Hi Pat

Do you have the same problem when you select all cells in the column
You can send me the workbook private if you want and I take a look at it

tomorrow.

Bedtime for me now

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message

...
Hello Ron,

Installed your beta version and i am getting an error: The header cell

is
empty, or there is no empty row above your headers.

I cannot understand why the above message appears because on the

EasyFilter
Sample DataBase it works fine. Any suggestions?

Pat



"Ron de Bruin" wrote in message
...
Hi Pat

Excel can't do this but my EasyFilter add-in have a option to do this
You can find it here

http://www.rondebruin.nl/easyfilter.htm
at the bottom of the page : Beta version 2.1


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message

...
Can anyone tell me if it is possible to filter only bold text in a

list.

Thanks












  #6   Report Post  
Ron de Bruin
 
Posts: n/a
Default Filter on bold

Congratulations on a handy filtering tool

Thanks

I will update the add-in soon with also a option for filter CF(conditonal formatting) colors.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message ...
On the test sheet I created there were a number of empty rows above the
column containing text. When I deleted all the empty rows the problem went
away.
Done a filter on cells containing bold text and it worked great.

Congratulations on a handy filtering tool.

Pat


"Ron de Bruin" wrote in message
...
Hi Pat

Do you have the same problem when you select all cells in the column
You can send me the workbook private if you want and I take a look at it

tomorrow.

Bedtime for me now

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message

...
Hello Ron,

Installed your beta version and i am getting an error: The header cell

is
empty, or there is no empty row above your headers.

I cannot understand why the above message appears because on the

EasyFilter
Sample DataBase it works fine. Any suggestions?

Pat



"Ron de Bruin" wrote in message
...
Hi Pat

Excel can't do this but my EasyFilter add-in have a option to do this
You can find it here

http://www.rondebruin.nl/easyfilter.htm
at the bottom of the page : Beta version 2.1


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pat" wrote in message
...
Can anyone tell me if it is possible to filter only bold text in a

list.

Thanks












Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EasyFilter 2.1 Beta : filter on Colors and bold cells Ron de Bruin Excel Discussion (Misc queries) 0 March 24th 05 03:36 PM
Macro for Filter Switches ... Maybe??? Ken Excel Discussion (Misc queries) 4 February 25th 05 05:30 PM
Filter Switches vs Macro? Ken Excel Discussion (Misc queries) 3 February 24th 05 10:31 PM
Pivot table and filter Bruce Roberson New Users to Excel 1 January 25th 05 04:00 AM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM


All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"