From the course: Excel: Tracking Data Easily and Efficiently

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Conditional formatting to warn of deadlines

Conditional formatting to warn of deadlines - Microsoft Excel Tutorial

From the course: Excel: Tracking Data Easily and Efficiently

Start my 1-month free trial Buy for my team

Conditional formatting to warn of deadlines

“

- [Instructor] This data tracker is based on a task that used to be part of my job years ago, and I'm going to share it with you. Here's a situation. I would get faxes. They would be from the bank where customers were challenging charges on their credit cards. I had to do the research to then reply. And the deadlines were very strict. If I missed a deadline, I would lose the challenge. That's it. Done, no appeals. So to help me out I wanted some visual clues that would be really easy for me to see. And conditional formatting helped. Here we have these disputes, the deadline, the response due, number of days until that deadline. And today is the 17th of October of 2023. See, I replied. And then here are notes. So let's do some conditional formatting to help us out. I'm going to highlight this column. I'm in the home tab of ribbon, going to conditional formatting, new rule. Use a formula to determine which…

Contents