Click the cell that has the conditional formatting you want to copy.Click Home > Format Painter. The pointer changes to a paintbrush. ... To paste the conditional formatting, drag the paintbrush across the cells or ranges of cells you want to format.To stop using the paintbrush, press Esc.
read more >>