4-15: Use Excel Conditional Formatting based on Dates, Values and Text
How to use simple conditional formatting in Excel. You'll color highlight cells based on values (like Greater Than, Less Than), Dates (like Today, This Week) and Text (like Contains "C-100"). You'll also learn how to apply multiple conditional formats to the same range.
This is the first of four conditional format tutorials and I recommend that you work through all four in sequence if you are new to Conditional Formatting. The lessons are:
Lesson 4-15: Use Excel Conditional Formatting based on Dates, Values and Text.
Lesson 4-16: Advanced Conditional Formatting Using the Rules Manager.
Lesson 4-17: Insert Data Bars, Color Scales and Icon Sets into Excel cells.
Lesson 4-18: Conditional Formatting with Formulas - Defining Custom Rules
This lesson will also show you how to apply very simple conditional formats using the Quick Analysis button, and how to clear conditional formatting from the entire worksheet, or from a range of cells within the worksheet.
As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson.
This video comes from the "Making Your Workbooks Look Professional" session (Session 4 in our YouTube Excel Essential Skills free video training course).