Where is Conditional Formatting in Microsoft Excel 2010 and Excel 2007

Home > Document > Excel > Where is Conditional Formatting in Microsoft Excel 2010 and Excel 2007

Where is Conditional Formatting in Microsoft Excel 2010 and Excel 2007

Used way to get Conditional Formatting if you are using Classic Menu for Office
Conditional Formatting in Microsoft Excel 2010/2007 Ribbon
More Skills for Microsoft Excel 2010/2007 Features

Used way to get Conditional Formatting if you are using Classic Menu for Office

Classic Menu for Office will bring you back to the familiar interface of Microsoft Excel 2003. Just click the “Format” item on the mail menu, you will find the “Conditional Formatting” item staying in the list.

The Conditional Formatting in Classic Menus

Know more about Classic Menu for Office

Conditional Formatting in Microsoft Excel 2010/2007 Ribbon

If you do not have Classic Menu for Office, and have never used Microsoft Excel 2010/2007 Ribbon before, it may be a little difficult to find out the “Conditional Formatting” button quickly in the completely new Ribbon at the beginning.

However, it is also very convenient to get this button after you are used to Microsoft Excel 2010/2007 Ribbon. Launch Microsoft Excel 2010/2007, click the “Home” tab, and go to the “Styles” group, then you will see the “Conditional Formatting” button there:

Conditional Formattign in Ribbon

It seems somewhat hard to get used to the new ribbon in a short time. Please do not worry about it! Classic Menu for Office brings back used classic styles interface of Microsoft Office 2003 with all new feature of Microsoft Office 2010/2007. Classic Menu for Office is an excellent helper to easy your learning curve.

Classic Menu for Office

Brings the familiar classic menus and toolbars back to Microsoft Office 2007 and 2010. You can use Office 2010 and 2007 immediately without any training. Supports all languages, and all new commands of 2007 and 2010 have been added into the classic interface.