cell format wihich highlights

AI Training: For Busy Decision Makers & Professionals Book now

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

resolvedResolved · Low Priority · Version 365

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?

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Generate randon numbers

Some 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:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.13 secs.