{"id":1110,"date":"2017-12-19T13:15:10","date_gmt":"2017-12-19T05:15:10","guid":{"rendered":"http:\/\/owa.sodexo-cn.com\/blog\/?p=1110"},"modified":"2017-12-20T15:43:22","modified_gmt":"2017-12-20T07:43:22","slug":"excel-custom-collation-to-achieve-special-requirements","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=1110","title":{"rendered":"[Excel] Custom collation to achieve special requirements"},"content":{"rendered":"<p>Sorting may be one of the most basic features of Excel. But have you ever tried to sort different cell colors, different font colors, and even different conditional formatting icons? Today will take you to further expand the use of sorting function ideas.<\/p>\n<h3>Custom collation to achieve special requirements<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1058\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/1.png\" alt=\"\" width=\"752\" height=\"232\" \/><\/p>\n<p>When you have a table like this, but you want to rearrange the table according to the following rules,<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1059\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/2.png\" alt=\"\" width=\"278\" height=\"39\" \/><\/p>\n<p>What do you think you should do?<\/p>\n<h3>Sort by cell color<\/h3>\n<p>To achieve sorting by cell color, you can actually do this:<\/p>\n<p>1.Select the cell you want to sort, and click Custom Sort.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1111\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/3eng.png\" alt=\"\" width=\"237\" height=\"228\" \/><\/p>\n<p>2.Then sort the basis by selecting the cell color<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1112\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/4eng.png\" alt=\"\" width=\"600\" height=\"275\" \/><\/p>\n<p>3.And then, it&#8217;s done.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1062\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/5.png\" alt=\"\" width=\"634\" height=\"192\" \/><\/p>\n<h3>Sort by cell font color and icon style in cell<\/h3>\n<p>In fact, similar to the cell color sorting, as long as the custom sort, set the appropriate collation, you can sort the font color and icon style.<\/p>\n<p>1.Sort by font Color<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1063\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/6.png\" alt=\"\" width=\"635\" height=\"193\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1113\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/7eng.png\" alt=\"\" width=\"600\" height=\"275\" \/><\/p>\n<p>2. Sort by cell icon<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1065\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/8.png\" alt=\"\" width=\"584\" height=\"229\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1114\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2017\/12\/9eng.png\" alt=\"\" width=\"600\" height=\"275\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sorting may be one of the most basic features of Excel. &#8230; <a title=\"[Excel] Custom collation to achieve special requirements\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=1110\" aria-label=\"\u9605\u8bfb [Excel] Custom collation to achieve special requirements\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1110","post","type-post","status-publish","format-standard","hentry","category-tips"],"views":2224,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1110"}],"version-history":[{"count":1,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1110\/revisions"}],"predecessor-version":[{"id":1115,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1110\/revisions\/1115"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}