00:00there are times in your excel data set where you have conditionally formatted your rows to
00:04illustrate bad actors like in my data set here where we have bad average and good year which
00:10are highlighted in red orange and white respectively now if i want to sort this
00:16row to organize the data visually and logically like this here are the steps on how you can sort
00:22the rows based on cell colors first you're going to start off by highlighting your header like this
00:27and you press ctrl shift l to enable filter once the filter is available click on the pull down on
00:33your region here and you go sort by color and then from this context menu you're going to select
00:38custom sort like this and this pop-up window will appear on the sort by you're going to select the
00:44header i'm going to start off with region and then the cell value or rather the sort on we'll be
00:49changing it to cell color and the order now here we can assign the color we're going to put the
00:54very
00:54top row as red now let's duplicate this same row using this copy level here like this and all you
01:01have to do is to assign the next one on the list which is going to be orange after that
01:07click ok
01:07and voila there you go you're done
