After you’ve created one or more conditional formats, you can edit, re-order, and delete the rules as necessary. In this video, learn how to manage the rules you’ve created.
- [Instructor] After you have created one or more conditional formats, you can edit, reorder, and delete the rules, as necessary. In this movie, I will show you how to manage the rules that you've created. My sample file is the Manage workbook, and you can find it in the Chapter 6 folder of the Exercise Files collection. It appears that cells B4 through B14 have at least one conditional format applied. If I want to discover what those rules are, I can select the cells, B4 through B14, then, on the Home tab of the ribbon, click the Conditional Formatting button, and then click Manage Rules.
And I see I do, in fact, have two rules. The first is, if a cell value is greater than 0.85 or 85%, apply a green background; and if it's greater than 0.8 or 80%, apply boldface. I don't have Stop if true selected for either rule. And, in this case, it would make a difference. If I were to check Stop if true, and then click OK, then you'll see if I click away that any value greater than 85% has a green background but no boldface, whereas values greater than 80% but less than 85% have boldface but no green background.
Now, I'll select those cells again, and go back to Conditional Formatting, and Manage Rules. If I want to edit a particular rule, well, the first thing I'll do is clear Stop if true, I can do so. For example, if I want to make the background color of my greater than 85% rule a lighter shade of green, I can select the rule, and then click Edit Rule. Then I can click the Format with control, click Custom Format, and then click Fill, if necessary, and click the Background color's down arrow, and I'll go one shade lighter, click OK, and click OK again, and again, and it's been applied.
You can also change the order of conditional formats. So I'll select the cells again, Conditional Formatting, Manage Rules. If I wanted to apply the cell value of greater than 0.8 rule first, then I could click that rule, and then click the move up button, or if I want to move it back down, I can click the move down button. If I want to delete a rule here, I can click it, in this case, the bottom rule, and click the minus button.
If I no longer want to delete it, I can click Cancel, and the action is undone. And, finally, I can clear conditional formatting rules from my workbook. I can do it from a selected range or I can do it from the workbook, or worksheet, as a whole. In this case, I've selected cells B4 through B14, click Conditional Formatting, and point to Clear Rules. And you can see here that I can either clear the rules from only the selected cells, from the entire sheet, or, grayed out because they don't apply with this current configuration, rules from this table, that would be an Excel table I've defined, or from a pivot table.
In this case, I will only clear rules from the selected cells, and when I click that option, they're gone. As with any other aspect of your workbooks, make sure your conditional formats are working correctly and providing the information you need. If you find a rule that's no longer needed or that you should change, you can do so quickly and easily.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.