Copy conditional formatting

1. Select the cells that contain the conditional format you would like to copy.

2. Go to Home and select   Format Painter. 

3. Select the additional cells you would like to paste the formatting. The cell format, including conditional formatting logic, and formulas are copied.

For more info on conditional formatting, see Use conditional formatting to highlight information.

1. Select the cells that contain the conditional format you would like to copy.

2. Go to Home and select   Format Painter. 

3. Select the additional cells you would like to paste the formatting. The cell format, including conditional formatting logic, and formulas are copied.

For more info on conditional formatting, see Highlight patterns and trends with conditional formatting in Excel for Mac.

1. Select the cells that contain the conditional format you would like to copy.

2. Go to Home and select   Format Painter. 

3. Select the additional cells you would like to paste the formatting. The cell format, including conditional formatting logic, and formulas are copied.

For more info on conditional formatting, see Use conditional formatting to highlight information.