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.
-
Click a cell that has the conditional formatting you want to copy.
-
Click HOME > Format Painter. The pointer changes to a paintbrush. Double-click Format Painter if you want to copy the formatting to multiple selections.
-
To copy the formatting, drag the mouse pointer across the cells or ranges of cells that you want to format.
-
To stop the formatting, press Esc.
Want more?
Apply conditional formatting to quickly analyze data
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.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
