![permanently keep source formatting word permanently keep source formatting word](http://computertutorflorida.com/wp-content/uploads/2017/01/paste-options4.jpg)
Select "Stop if true" on each formula to help improve performance
![permanently keep source formatting word permanently keep source formatting word](https://media.gcflearnfree.org/ctassets/topics/255/default_set.png)
Leave the Find what and Change to fields empty, but click on the More Options button to display the Find and Change format sections of the dialog box. eg = AND(A$1="Y") and put "Y" in row 1 for all columns that require the format In order to retain the formatting that you want to keep, open the Find/Change dialog box by choosing Edit > Find/Change. You will likely need to include an AND statement in every conditional format formula to stop it from formatting cells in unwanted columns outside your desired range. In the Cut, copy, and paste section, select the Show Paste Options button when content is pasted check box. In Word 2007, click the Microsoft Office Button Office button image, and then click Word Options > Advanced. Note that EndNote reformats the references in the. In Word 2010, 2013, or 2016, click File > Options > Advanced. Word displays the Modify Style dialog box. You should see a down-arrow appear at the right side of the style name. After selecting the desired format, click on the Format button. Hover the mouse pointer over a style name in the Styles window. In the pop-up window, select the document to format (by default it is the current document) and the style. This forces the values 1, 0 and -1 to all display a filled circle, with the ability to then use conditional formatting to change the colour based on the underlying number value Formatting references: Return to Word and select Format Bibliography from the EN submenu of Word’s Tools menu ribbon.
![permanently keep source formatting word permanently keep source formatting word](http://projectwoman.com/wordpress/wp-content/uploads/2011/04/word_2007_image_insert_default_setting.jpg)
It only works for conditional formats based on a formula however, you can mimic (for example) traffic light icons by using character "l" in the Wingdings font and then applying a custom number format of on the required range. If you set the conditional format range as entire rows eg ($5:$50), you can then insert new rows within this range to automatically expand it to ($5:$51) without it breaking into pieces. I have been experimenting with a rough workaround for this problem that applies if you only need to insert new rows OR columns but not both