Two ways to do it.
Click AC, click on the required effect, click and drag the mouse cursor across the cells you want to apply the effect.
or Click AC, click on the Select tool, click and drag the mouse cursor across the required cells, click on the effect button you require.
then deselect AC to work on the effect.