Home > Documents > Office > Where is Edit Conditional Formatting in Microsoft Office 2007/2010/2013

 

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

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

• Method A: If you have Classic Menu for Office
• Method B: If you do not have Classic Menu for Office

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

• Where is Office 2007 Classic View
• Where is Office 2010, 2013, 2016, 2019 and 365 Classic View
• Where are Office 2007 Toolbars and Menus
• Where is Office 2010, 2013, 2016, 2019 and 365 Menu and Toolbar
• Where is File Menu
• Where is Format Menu
• Where is Tools menu
• More...

 

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

 

		Classic Menu for Office It includes Classic Menu for Word, Excel, PowerPoint, Access, Outlook, OneNote, Publisher, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365 (includes Office 365).
		Classic Menu for Office 2007 It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.