![]() Second, it extends the criteria for the formatting rule so that only those tasks where the due date is in the past AND the task is still open will be highlighted - at a glance, we can tell which tasks are overdue and need attention.First, it shows you how to apply a format to a cell containing a date where that date is in the past - this allows us to see which of the tasks in our project are overdue. ![]() This lesson uses a Project Checklist example to demonstrate how to use Conditional Formatting. You can even use the value of other cells in the worksheet as part of your conditional formatting criteria. It allows you to apply formatting to cells or ranges of cells based on criteria that you can choose. Excel's Conditional Formatting feature is incredibly powerful.
0 Comments
Leave a Reply. |