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.
Source: howtogeek.com