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

ResolvedVersion 365

Wed 13 Apr 2022, 12:29 Delegate 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:45 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

New to Excel 2010 - Sparklines!

Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting.

>insert
>sparklines
>Choose any style you want

You will be asked for the range and it will automatically select the cell your in to insert the sparklines.

View all Excel hints and tips

Cell Format wihich highlights a date longer than a year

Cell Format wihich highlights a date longer than a year

RE: Cell Format wihich highlights a date longer than a year

Excel articles

Excel tip:

New to Excel 2010 - Sparklines!