课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Conditional formatting to warn of deadlines

Conditional formatting to warn of deadlines - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

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…

内容