Sign in

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.