copy cells and format color

Copper Contributor

I want to copy a range of cells with conditional formatting and want to copy the value as well as the formatting.

My data is a filtered data set

1 Reply


To copy a range of cells with conditional formatting, including both the values and the formatting, you can use the "Format Painter" feature in Excel.

Here is how you can do it:

  1. Select the range of cells that you want to copy the values and conditional formatting from.
  2. On the "Home" tab in the Excel ribbon, find the "Format Painter" button. It looks like a small paintbrush icon.
  3. Click on the "Format Painter" button. Your cursor will now turn into a paintbrush icon.
  4. Now, select the range of cells where you want to apply the copied values and formatting. Excel will apply the same conditional formatting rules to this new range.
  5. Once you have painted the formatting to the new range, you can release the mouse button.

The conditional formatting rules from the original range should now be applied to the new range, along with the values.

Keep in mind that the Format Painter works with the currently visible cells, so if you have a filtered data set, make sure the range you are copying from includes all the relevant cells, even if they are hidden due to filtering. Additionally, if you are copying to a range that is not adjacent to the original range, you might need to reapply the conditional formatting rules manually. The text and steps were created with the help of AI.


My answers are voluntary and without guarantee!

Hope this will help you