trang chủ > Document > Excel > Where is Conditional Formatting in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365
*

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

Classic menu for Office will bring you back to lớn the familiar interface of Microsoft Excel 2003/XP(2002)/2000. Just click the “Format” nhà cửa on the mail menu, you will find the “Conditional Formatting” công trình staying in the list.

Bạn đang xem: Where is conditional formatting in excel 2007, 2010, 2013, 2016, 2019 and 365

*

Know more about Classic menu for Office

Conditional Formatting in Microsoft Excel 2007/2010/2013/2016/2019 Ribbon

If you vày not have Classic menu for Office, và have never used Microsoft Excel 2007/2010/2013/2016/2019 Ribbon before, it may be a little difficult lớn find out the “Conditional Formatting” button quickly in the completely new Ribbon at the beginning.

However, it is also very convenient khổng lồ get this button after you are used khổng lồ Microsoft Excel 2007/2010/2013/2016/2019 Ribbon. Launch Microsoft Exce, click the “Home” tab, và go to the “Styles” group, then you will see the “Conditional Formatting” button there:

*

It seems somewhat hard lớn get used to the new ribbon in a short time. Please vị not worry about it! Classic thực đơn for Office brings back used classic styles interface of Microsoft Office 2003 with all new feature of Microsoft Office 2007, 2010, 2013, 2016, 2019 và 365. Classic thực đơn for Office is an excellent helper lớn easy your learning curve.

*
More Related Articles...

Classic menu for Office

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

*
Classic menu for Office

It includes Classic menu for Word, Excel, Power
Point, One
Note, Outlook, Publisher, Access, Info
Path, Visio & Project 2010, 2013, 2016, 2019 and 365.

*
Classic menu for Office 2007

It includes Classic thực đơn for Word, Excel, Power
Point, Access and Outlook 2007.

Introduction

*
Let's imagine you have a spreadsheet with thousands of rows of data. It would be extremely difficult to lớn see patterns and trends just from examining the raw data. Excel gives us several tools that will make this task easier. One of these tools is called conditional formatting. With conditional formatting, you can apply formatting to one or more cells based on the value of the cell. You can highlight interesting or unusual cell values, & visualize the data using formatting such as data bars.In this lesson, you will learn how khổng lồ apply, modify, & delete conditional formatting rules.

Conditional formatting


Download the example lớn work along with the video.

The conditional formatting options

You have many conditional formatting rules, or options, you can apply lớn cells in your spreadsheet. Each rule will affect selected cells differently. Before you choose a formatting rule, you must identify what questions you are trying khổng lồ answer. For example, in a sales spreadsheet you might want lớn identify the salespeople with lower than average sales. To vày this, you need to choose a conditional formatting rule that will show you this answer. Not all of the options will provide you with this information.

Some of the conditional formatting options include:

Highlight cell rules: This rule highlights specific cells based on your option choice. For example, you can choose for Excel lớn highlight cells that are greater than, less than, or equal lớn a number, và between two numbers. Also, you can choose for Excel to lớn highlight cells that contain specific text, including a specific date. If you choose this option, a dialog box will appear, và you will have lớn specify the cells lớn highlight & the color you would lượt thích to highlight the cells.
*

*

Top/bottom rules: This conditional formatting option highlights cell values that meet specific criteria, such as top or bottom 10 percent, above average, & below average. If you choose this option, a dialog box will appear, và you will have lớn specify the cells khổng lồ highlight and the màu sắc you would lượt thích to highlight the cells.
*

*

Data bars: This is an interesting option that formats the selected cells with colored bars. The length of the data bar represents the value in the cell. The longer the bar, the higher the value.
*

Color scales: This option applies a two- or three-color gradient lớn the cells. Different shades and colors represent specific values.
To apply conditional formatting:Select the cells you would like to format.Select the Home tab.Locate the Styles group.Click the Conditional Formatting command. A thực đơn will appear with your formatting options.
An additional dialog box may appear, depending on the option you choose.If so, make the necessary choices, then click OK.To remove conditional formatting rules:Click the Conditional Formatting command.Select Clear Rules. A cascading menu appears.Choose to lớn clear rules from the entire worksheet or the selected cells.To manage conditional formatting rules:Click the Conditional Formatting command.Select Manage Rules from the menu. The Conditional Formatting Rules Manager dialog box will appear.
From here you can edit a rule, delete a rule, or change the order of rules.

Xem thêm: Những Bài Thơ Hay Về Tình Bạn Trên Facebook, Trang Thơ Tình Bạn(Tt)

Challenge!

Use the Company Sales workbook to complete this challenge.

Apply conditional formatting khổng lồ a range of cells with numerical values.Apply a second conditional formatting rule to the same phối of cells.Apply a conditional formatting rule to a range of cells with text.Explore the Conditional Formatting Rules Manager dialog box.Clear all conditional formatting rules from the worksheet.