Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Here's a solution to sort by any type of format.
1. In visual basic, paste in this code. Function CellFormat(cell_to_test As Range) As String CellFormat = cell_to_test.Font.Color & " " & cell_to_test.Interior.Color & " " & cell_to_test.Font.Size & " " & cell_to_test.Font.FontStyle End Function 2. Insert a column into your spreadsheet called something to the effect of "Cellformat." 3. =cellformat(H7) is now the function to identify your formatting based on your macro definition in step 1. 4. The output of your new funtion will be: 0 10092543 10 Regular, 0 16777164 10 Regular,16711680 16777215 10 Bold 5. You can now sort on this CellFormat column. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Rows by Color | Excel Discussion (Misc queries) | |||
Changing color in color palette | Setting up and Configuration of Excel | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Inserts and color fill | New Users to Excel | |||
A different "Fill Color" problem | Excel Worksheet Functions |