How to copy conditional formatting

You can download here the worksheet from this video to practice it by yourself!

Developing the set of rules to conditionally format a given table might be time-consuming.
It might come as an unwanted surprise then, if you have successfully completed all formatting but have realized that not all of the cells that you wanted to format were included. What should you do now, select the remaining cells and start all over again?

Luckily, the format painter comes in very handy for that. It is good to bear in mind that the format painter copies not only regular formatting, but conditionally formatting rules as well.

Once you know how to use it, you will notice how easy it is to use. Follow these simple steps (or watch the accompanying video above) to duplicate any formatting you have previously created onto a new selected range.

Steps for using the painter:

  1. Right click a 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.