Auto Sort by Color
Dear Sir,
I have data of works to be completed. using the conditional formatting i formatted the cells using search function. and i trying to insert auto sort function based 1. type of goods 2.on cell color. i tried but can't find the suitable code. please help me to solve this code. find the attachment for your reference
Record a macro. Select cell C6, switch on AutoFilter, sort column C by colour | Custom.
Needs tidying up but that's the basic code. I chose to put green on top.
Option Explicit Sub Macro1() ' ' Macro1 Macro ' ' Range("C6").Select Selection.AutoFilter ActiveWorkbook.Worksheets("May 2016").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("May 2016").AutoFilter.Sort.SortFields.Add(Range( _ "C6:C26"), xlSortOnCellColor, xlAscending, , xlSortNormal).SortOnValue.Color = _ RGB(146, 208, 80) With ActiveWorkbook.Worksheets("May 2016").AutoFilter.Sort .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the code.
but i want the code Auto sort based on two conditions that is
1. based on type of goods and
2. based on status of goods
Description of conditions excel: if i the goods delivery status is pending it will be shown as orange color or if goods delivered it will be shown as green color, on the mark of status "pending" to "delivered" it will be change it to green color and it should be automatically sorted green color first than orange color will be second.
Advance thanks for your help .:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
indhrui 
Register To Reply
Bookmarks