Click the cell containing the conditional format you want to copy. Click Home, then click to select Format Painter, which appears next to Copy, Paste and other editing functions.

To use the Format Painter, select the cell or cells whose formatting you want to copy, and click "Format Painter" in the Clipboard group of the Home tab on the ribbon.

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

Use this step-by-step guide to copy format in Excel worksheet columns and rows and improve your data presentation and organization.

References Microsoft Support: Copy the Formatting of an Object, Worksheet Cell, or Text by Using Format Painter Excel 2007 All-In-One Desk Reference For Dummies; Greg Harvey ...