Excel is an incredibly powerful spreadsheet application, but it can sometimes seem a little dumb. You’ve got data that’s clearly in a standard date format, but for some reason, Excel isn’t recognizing the ce
How to use Conditional Formatting to highlight past due dates in Excel You will apply a formula in the example to determine “past due dates.” The formula will check if the variance between dates exceeds a certain number of days. To create a color-coded table, use three conditional formatt...