=AND(D1<>"";DAYS360(D1;TODAY())>=70)
Copy the formula to all cells in column D.
Here is a video demonstrating this:
Friday 1 February 2013
How to highlight dates that are older than 70 days using Excel's Conditional Formatting
Following video demonstrates how to use Excel's conditional formatting to highlight dates that are older than 70 days. The formula takes into account that empty cells won't be highlighted. Following formula in D1's Conditional Formatting does the trick:
Copy the formula to all cells in column D.
Here is a video demonstrating this:
Copy the formula to all cells in column D.
Here is a video demonstrating this:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment