To control more precisely what cells will be formatted, you can use formulas to apply conditional formatting.
Other videos in this course
This video is part of a training course called Take conditional formatting to the next level. You can download the entire course or watch the videos online:
- Video: Take conditional formatting to the next level. Watch this video to learn how to apply conditional formatting to specific cells, tables, PivotTables, and worksheets. You can also format cells that are blank or contain errors.
- Video: Use formulas to apply conditional formatting. (You are here!) To control more precisely what cells will be formatted, you can use formulas to apply conditional formatting.
- Video: Manage conditional formatting. In the Conditional Formatting Rules Manager you can choose to show formatting rules for areas of a workbook that have rules, such as the current selection or a specific worksheet. You can then create, edit, and delete rules as well as manage the precedence of rules for the cells or worksheet you selected.
Need a reminder of what you learned? See the course summary.
Ready for another tutorial? See the complete list of Excel 2013 training courses.