Copy Conditional Formatting To Other Cells

The conditional formatting can easily be copied by using the format painter:
1. Right click the cell that already contains the desired conditional formatting rule.

2. Select the format painter from the mini toolbar.

3. Select the desired range of cells where you wish to apply that rule.

That’s it! The rule is now applied to the selected range.