Microsoft went a step further in Excel 2013 and created Flash Fill. This new feature recognizes patterns in your data and will finish tedious tasks for you. Produced by Sara Silverstein ...

Then, click the Drawing toolbar’s Fill Color tool and select a color from the palette. As soon as you do, Excel changes the background of your chart, filling it with the color you selected.