![]() Point to Highlight Cell Rules, and click Between. Quick Analysis doesn’t have this option, so I click the Conditional Formatting button on the HOME tab where there is this option. I’d like to see at a glance what tasks are coming due over the next week, so I can keep a close eye on them. Tasks that aren’t due for a week or more show in green. I’ll select the green option, and click OK. ![]() Notice that there are many formatting options, including Custom Format. These tasks are in good shape.Ĭonfiguring conditional formatting for this is similar to what we did for overdue tasks, except I click Greater Than, I type the TODAY function, a plus sign, and 7. ![]() I also want to see tasks that aren’t due for a week or more. Tasks that are overdue show in red and are easy to pick out at a glance. I am going to leave the formatting set to the default red option, and click OK. Instead, I type the TODAY function, which returns today’s date.Įquals sign, TODAY, opening parenthesis, and a closing parenthesis. I could type today's date, but I’d have to update the conditional formatting every day. I select the cells in the Due date column, click the Quick Analysis button, click Less Than. ![]() In other words, those tasks with the due date before today. I want to see at a glance what tasks in the list are late.
0 Comments
Leave a Reply. |