Excel automatically copies the formatting into the range when you release the mouse button. To copy conditional formats multiple times, double-click Format Painter.

If keyboard shortcuts are not working in Excel first check Macro settings or disable Transition navigation keys and see. More suggestions here.