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

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

How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365?
Just download Classic Menu for Office 2007 or Classic Menu for Office
Kutools for Excel: 120 Powerful New Features for Excel.
Office Tab: Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.


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

 

Back to Top

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

Classic Look of Word 2007/2010

 

 

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.

 

 

 
 

2001- Addintools. All rights reserved.  Privacy Policy  |  Contact Us
If you have any questions or suggestions about our products or web site, please feel free to submit them to us. Thank you very much.