Google Sheets Copy Conditional Formating to Multiple Cells

May 25, 2019

Select a cell with existing conditional formating applied, the copy the cell (Edit -> Copy).

Select a new cell or a range to cell to apply the conditional formating, the Right Click / Edit -> Paste Special -> Paste Conditional Formating only.

NOTE: Once the paste is done, you need to copy again before the next paste could be done.

NOTE: All the cells will share the same conditional formating. You can change the conditional formating (e.g. change text color) and it shall be applied to all cells with the same conditional formating.

This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.