Where is Edit Conditional Formatting in Office 2007, 2010, 2013, 2016, 2019 and 365

IF statements allow you to compare two values and display document content based on the result of the comparison. When used in a Word template, IF fields are. MS word 2016 conditional formatting is present in tab. MS word 2016 conditional formatting is present in tab. March 3, 2021 – by Javed 0 (A) home (B) design (C) view. Another option would be to use a Word document with an OLE Microsoft Excel object. The drawback is the users would need to know how to use this embedded Excel object. The third way you could go is to use Microsoft Excel and use the inbuilt Conditional Formatting of Excel.

Where is Edit Conditional Formatting in Excel 2007/2010/2013

Other Office 2007/2010/2013/2016/2019 applications (except Excel) do not support Conditional Formatting feature.

Where is Edit Conditional Formatting in Excel 2007/2010/2013

Classic Menu for Office will show the Microsoft Office 2007/2010/20130 in the old view of Office 2003/XP(2002)/2000, with bringing back the old drop-down menus and toolbar.

Method A: Familiar way to find out Conditional Formatting in menus if you have Classic Menu

• Click the Format menu under Menus tab;
• Move mouse over the Conditional Formatting, and you will view several sub-items of Conditional Formatting.

Fig. 1: Conditional Formatting in Excel 2010's Format Menu

Click to know more information and free download Classic Menu for Office

The Conditional Formatting including 8 sub-items, including Highlight Cells Rules, Top/Bottom Rules, Data Bars, Color Scales, Icon Sets, New Rule, Clear Rules, and Manage Rules. If you want to edit the Conditional Formatting, click one of them.

Method B: Seek for Conditional Formatting in Ribbon if you do not have Classic Menu

• Click the Home Tab;
• Go to the Styles group;
• Click the Conditional Formatting button, and you will see items in the drop down list.

Fig. 2: Conditional Formatting in Excel 2010's Ribbon

Where is Conditional Formatting in other Office 2007/2010/2013/2016/2019 applications

The Other Microsoft Office 2007/2010/2013/2016/2019 applications do not support Conditional Formatting feature. Therefore, it is not possible for you to find out the Conditional Formatting command in Microsoft Word, PowerPoint, Outlook 2007/2010/2013..., and more.

Click to know more information and free download Classic Menu for Office

More tips for Microsoft Office 2007, 2010, 2013 and 365

Classic Menu for Office

Brings your familiar old menus and toolbars of Office 2003 (2002, 2000) back to Microsoft Office 2007, 2010, 2013 and 365. You can use Office 2007/2010/2013/2016 (includes Office 365) immediately and efficiently, and don't need any trainings or tutorials when upgrading to Microsoft Office (includes Word, Excel, and more ...) 2007, 2010 or 2013.

Screen Shot of Classic Menu for Word

Conditional Formatting In Word 2013

Word templates introduced in CRM Online and CRM 2016 are not the easiest contraptions to edit. One of the questions that popped up in a recent conversation was how to use conditional IF in the document generation.

tl;dr

To refer to the control values after the document has been generated, wrap content controls using bookmarks defined at the control container level.

Longer

CRM fields are defined as Content Controls and in theory we could have written some simple VBA using ContentControl object. Except that CRM does not play nice when generating the document and simply replaces all content controls with the record values.

How To Use Conditional Formatting In Word

The solution is to wrap the content controls using the bookmarks defined at the container level, i.e. cell, row, paragraph, etc. Then this bookmark can be used as a reference in a conditional expression of the IF field.

Conditional Formatting In Word Tables

For example, to insert conditional text depending on the total invoice value:

Conditional Formatting In Word 2010

1. Extract the Invoice template that comes with the sample data and save it under a different name.
2. Open the template, find total amount, select the entire table cell and click Insert > Bookmark.
3. Type totalbookmark as a bookmark name, click Add.
   
4. Delete the words “Thank you for your business” and click Insert > Quick Part > Field.
5. Select IF field and type the following field code:
   IF totalbookmark > 100 “Thank you for you business!” “Thanks for nothing!”
6. Click OK. Hint: to see and edit field codes in the document, press Alt-F9.
7. Save the file and upload to CRM as a new template.
8. Create an invoice and generate the invoice document.
9. Enable document for editing, press Ctrl-A to select the entire content and press F9 to refresh the field content
10. Depending on the total value of the invoice, the document will say “Thank you for your business!” or “Thanks for nothing!”
    

It’s not a full automation that potentially could be improved with some VBA (I’m not 100% sure if it will work) but it’s a step in the right direction and a cheap way to add some pizazz to your documents.