Copy and paste conditional formatting to other cells

You can't add conditional formatting to your worksheet in Excel Online, but if the workbook you opened has conditional formatting, you can copy that formatting to other cells with similar data. Here's how:

  1. Select the cells with the conditional formatting you want to copy to other cells.

  2. Right-click the selection > Copy, or press Ctrl+C.

  3. Select the first cell in the destination area where you want to paste the conditional formatting.

  4. Click Home > Paste arrow > Paste Formatting.

    Paste Formatting option

    Note: Because you want to paste the formatting only, don't right-click > Paste, or press Ctrl+V. Also, if you've copied data that's in a different number format from the data in the destination area, make sure you adjust the number format in the destination area after you paste the formatting.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!