drag the selected cell’s fill handle. An AutoFill Options button will appear on the bottom right of the cell. Select the cells and drag the fill handle down. Click the AutoFill Options button.

you can also select the Background button to add a blend to the shape. A Gradient Fill is a shape fill that gradually transitions from one color to another across the surface of the shape.