Use conditional formatting

Copy and remove

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

This video shows you how to quickly copy a cell’s formatting, remove conditional formatting from specific cells, and remove all conditional formatting from an entire worksheet.

Copy conditional formatting

If you have a conditional formatting rule that you want to use for new data, copy the conditional formatting to the new data using the Format Painter.

  1. Click a cell that has the conditional formatting you want to copy.

  2. Click HOME > Format Painter. The pointer changes to a paintbrush. Double-click Format Painter if you want to copy the formatting to multiple selections.

  3. To copy the formatting, drag the mouse pointer across the cells or ranges of cells that you want to format.

  4. To stop the formatting, press Esc.

Want more?

Apply conditional formatting to quickly analyze data

Add, change, find, or clear conditional formats

Take conditional formatting to the next level

I’ve already applied conditional formatting to cell B2. If the cell contains the text “oil”, the cell's formatting is red.

To copy the cell’s formatting, I select the cell, click Format Painter on the HOME tab, and select the cells I want to format.

To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and click Clear Format.

To remove all conditional formatting from the entire worksheet,click the Conditional Formatting button on the HOME tab, point to Clear Rules, and click Clear Rules from Entire Sheet.

Now, you have got a pretty good idea about how to apply conditional formatting.

Of course, there is always more to learn.

So check out the course summary at the end, and best of all, explore Excel 2013 on your own.

Expand your 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.

×