Sorting and Filtering by font
 

Microsoft should create a sort feature that allows you to filter out certain
fonts or sort fonts in a certain order. A filter would be much better, It
could be seperate from the filter that they have now. It should be a
completely seperate function that way you can still filter the column info
and also filter out other info in the same column, like font.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Sorting and Filtering by font
 

Hi ____.
The word you are trying to use is separate.

Actually I'm rather curious why you would want to sort on the font name.

You could use a User Defined Function to obtain the font name.
I don't think you are going to have much luck with your question as worded
even over a number of years because that is a user defined function or
as subroutine kind of thing.

Font
http://www.mvps.org/dmcritchie/excel/font.htm
Show FORMULA or FORMAT of another cell
http://www.mvps.org/dmcritchie/excel...tm#getfontname

Function getFontName(cell As Range) As String
getFontName = cell.Font.Name 'D.McR formula.htm
End Function

Instructions to install a macro or a user defined function in
http://www.mvps.org/dmcritchie/excel/getstarted.htm

To use if in same workbook
=GetFontName(A1)
To use if if your personal.xls workbook for use in other workbooks
=personal.xls!GetFontName(A1)

Use of your actual name in a technical newsgroup would be appreciated by people
taking the time to answer your question. We are a friendly group.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"drob77777" wrote...
Microsoft should create a sort feature that allows you to filter out certain
fonts or sort fonts in a certain order. A filter would be much better, It
could be seperate from the filter that they have now. It should be a
completely seperate function that way you can still filter the column info
and also filter out other info in the same column, like font.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc