98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell Format wihich highlights a date longer than a year
Cell Format wihich highlights a date longer than a year
Resolved · Low Priority · Version 365
Wed 13 Apr 2022, 12:29Delegate Alana said...
Alana has attended:
Excel Intermediate course
Cell Format wihich highlights a date longer than a year
can someone help me, i have a spreadsheet where i input dates for each person and i want it to highlight if the date is over a year old?
Wed 13 Apr 2022, 23:45Trainer Dennis said...
RE: Cell Format wihich highlights a date longer than a year
Hi Alana
You would need to use the 'Use a formula to determine..' option.
The formula needs to equate to TRUE for the conditional format to be applied.
Something like =(TODAY()-B3)>365
B3 is the cell containing the date you want to check.
Regards
Dennis
Wed 20 Apr 2022: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Generate randon numbersSome types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it: |
