Need help with a sort marco

The attached image just has dummy data Example1.jpg but I need to make a macro that when I run it, it changes the order of accounts to be listed in the following order

From highest Utilization to lowest utilization then from highest rate to lowest rate, putting the ones with no utilization at the bottom sorted by rate.

Here is the spreadsheet. All values are dummy

Originally Posted by abousetta

Modified code:

Please Login or Register  to view this content.

Some of your fields are text that look like numbers. You might want to correct this as this can cause major calculation problems down the line.

Which fields have numbers as text?

try

Please Login or Register  to view this content.

My debt plan.xlsmI think I corrected that but I have a new problem when I hit sort accounts it's now putting the accounts with 0 balance at the top and flagging them all as close to the due date when it should only me marking the accounts that need to be paid within 9 days as due. I'm using conditional formatting to have it do the marking of accounts

The two conditional formatting rules I'm using are

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.