How to Copy Conditional Formatting in Microsoft Excel
If you use conditional formatting in Microsoft Excel to automatically format cells that match criteria, you may want to apply the same rule to another part of your sheet or workbook. Instead of creating a new rule, just copy it.
Microsoft Excel Copy Excel Formatting Easy Way Format Painter Conditional Formatting Rules Manager Conditional Formatting
Source: howtogeek.com