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.
Read This Article on How-To Geek ›
Source : How to Copy Conditional Formatting in Microsoft Excel
