In this video, I show how to apply conditional formatting to a new column of data in Microsoft Excel 2016. Using the conditional formatting (cell fill color), I sort data, leaving the blank cells at the bottom and the colored cells at the top of the column.