Since conditional formatting allows you to specify multiple rules on the same data set, doing it again for different data sets could be time-consuming.įor example, suppose you have a dataset as shown below, where student’s marks are highlighted in red if it is less than 35 and in green if more than 80. One of my favorite uses of Format Painter is to copy conditional formatting. You can use format painter to instantly apply the same formatting that is used in the existing data set (as shown below).Įxample 2 – Copying Conditional Formatting using Format Painter Suppose you have a dataset with existing formatting and you add a new column to this data set. Example 1 – Adding formatting for an Extended Dataset Let’s dive in to see some examples of using Format Painter in Excel. Copy formatting to some other workbook.Copy formatting to some other worksheet in the same workbook.Copy formatting from the same worksheet.Number formatting (note the $ sign and the two decimals).įormat Painter only copies the formatting and not the value in the cell.Here is what all is copied by format painter in this above example: This indicates that the format painter is active. Note that when you click on the Format Painter icon in the ribbon, the cursor changes and you can see a brush in it. Instantly, the formatting from cell B2 would be copied to cell D2 (as shown below). Select the cell where you want to copy the formatting.Go to the Home Tab –> Clipboard –> Format Painter.Select the cell(s) from which you want to copy the formatting.Here are the steps to copy formatting using Format Painter in Excel: Suppose I have a cell (B2 as shown below) and I want to copy the formatting from it to cell D2. Let’s understand Format Painter in Excel using a simple example. it will get transformed into the same formatted data where you did everything manually. You can now quickly copy the formatting you had already done, and paste it into the new dataset.Īnd woosh. This is where Excel Format Painter comes into the picture and saves you a lot of time. This may include applying borders, formatting the headers, adjusting column widths, removing gridlines, etc.Īnd while you’re patting your back for turning ugly data into a beautiful one, you get another file that needs to be formatted the same way. You get plain ugly data from a colleague, and you spend the next few minutes applying some formatting to make it beautiful. Keeping the Format Painter Active (to reuse it multiple times)Įxcel Format Painter is a nifty tool that allows you to copy formatting from a range of cells and paste it somewhere else in the worksheet (or other worksheets/workbooks).Example 2 – Copying Conditional Formatting using Format Painter.Example 1 – Adding formatting for an Extended Dataset.Using Format Painter in Excel – Examples.
0 kommentar(er)
