I have a spreadsheet with some dates in a column. Does anyone know if it's possible to change the way the date is displayed once the current date is 6 months further on? In other words if the date in the cell is the 12/09/06 and the current date is 13/03/07 then the 12/09/06 will change colour or have the cell filled with a colour. I hope this is clear.
Any Excel experts here?
- Thread starter gcol
- Start date
Sponsored Links
- Joined
- 24 Sep 2005
- Messages
- 6,345
- Reaction score
- 268
- Country
I'm no expert but this works ok... Excel 2000
To achieve this :-
You could use this, viewed as formulae :-
Where the function '=Today()' returns current date... format cell as date.
'Period days' is the number of days to look back before changing format format cell as number, this is a variable so you can use a number of your choice.
'Six m prev' - Is merely 'Today-182(days)' format cell as date.
The column of dates are formatted using 'Conditional formatting'
Effectively saying if any date in the column is 'greater than' or 'equal to' 182 days older than today, then hi-light that date, through 'Format' 'Patterns' with a cell fill - Yellow in this case.
To achieve this :-
You could use this, viewed as formulae :-
Where the function '=Today()' returns current date... format cell as date.
'Period days' is the number of days to look back before changing format format cell as number, this is a variable so you can use a number of your choice.
'Six m prev' - Is merely 'Today-182(days)' format cell as date.
The column of dates are formatted using 'Conditional formatting'
Effectively saying if any date in the column is 'greater than' or 'equal to' 182 days older than today, then hi-light that date, through 'Format' 'Patterns' with a cell fill - Yellow in this case.
Nice one, thanks pip.
Sponsored Links
Similar threads
- Igorian
- Software
