mightymacros Excel Utilities
Latest Version 4.5.9
A row color sort has been added to the tool set collection under the row tools menu. The tool will sort row colors on a sheet having up to 7 colors. The sort configuration can be stored and used across multiple worksheets. A typical use might be applicable when sorting row data highlighted with styles of Good, Bad and Neutral. In cases where the top row is row 2 or row 3, the row number should be selected in the forms drop box before selecting the input column range. The latest modification brings the tool inline with Excels default color sort, providing the ability to color sort on a filtered list.
Row Color Sort Video
mightymacros Excel Utilities Help File
Installation Instructions for Installing an Excel VBA Add-in
4. Select Macro Settings And Check 'Allow access to VBA project object model'
Select any Macro Setting other than 'Disable all macros without notification'.
7. Paste The xlam File Into The Browse Window
Make sure that Browse Path is C:\Users\[User]\AppData\Roaming\Microsoft\AddIns
Paste File and click OK button.
Note: If updating an earlier version uncheck the add-in in the add-ins dialog view then click OK to close the dialog, then follow the above steps to reopen the Add-ins dialog and go to the Browse window, paste and replace the old file, then select OK.