If you have a conditional formatting rule you want to use for new data, copy the conditional formatting to the new data using the Format Painter.
- Click a cell that has the conditional formatting you want to copy.
- On the Home tab, click Format Painter . The pointer changes to a paintbrush.
Note Double-click the Format Painter button if you want to copy the formatting to multiple selections.
- To copy the formatting, drag the mouse pointer across the cells or ranges of cells that you want to format.
- To stop the formatting, press Esc.
More about conditional formatting