Music, well hello and boom-shaka-laka! You know, a question I get asked a lot when I'm teaching a live Excel class is if there is a way to show in a date field when something is expired or past due, or when something is getting close to an expiration date or a due date, or when something is comfortably not even close to being expired or due. Well, there is a great way to use a feature in Excel called conditional formatting to do that for you, and I just wanted to show you two quick ways to do it here in Excel. So, what I have here is two columns: one labeled "expiration date" and another labeled "due date," but they have the exact same dates. The parameters I'd like to set up are as follows: if today is a day when the expiration date has already passed, I want to initially shade the expiration date field with red. If the expiration date is within 30 days of expiring, I want to shade it with yellow. And if the expiration date is 30 days or longer in the future, I want to shade it with green. Let's go ahead and do that. First, I'll highlight this group of cells. You can highlight an entire column if you want, but for now, I'll stick with these three cells right here. I'll go up to the conditional formatting button, drop down to "highlight cell rules," and select the "less than" condition for my first rule. I want to format cells that are less than or equal to today. I'll choose a light red fill and dark red text for this condition. Now, let's move on to the yellow condition. With the same range selected, we'll add a second condition. We'll go to "highlight cell...
Award-winning PDF software
Video instructions and help with filling out and completing Form 8865 Expired
