View Single Post
  #4   Report Post  
Scott
 
Posts: n/a
Default

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.