deans6571
Prominent Member
- Joined
- Dec 12, 2008
- Messages
- 3,071
- Solutions
- 1
- Reaction score
- 2,813
- Points
- 978
- Location
- South London
...so in my spreadsheet in column F (MS Office 2013), I have dates (one date per cell) in the format 27/05/2020 .
I want to format the whole of column F so that when the dates go in the past (so tomorrow, the above date will be in the past), the cells get highlighted and stay highlighted.
I thought Conditional Formatting could do this but I don't see an option to keep these cells highlighted - this only gives an option to highlight cells that are 'yesterday' or 'last month' and when the dates go past 'yesterday' or 'last month' they get unhighlighted?!
I want to format the whole of column F so that when the dates go in the past (so tomorrow, the above date will be in the past), the cells get highlighted and stay highlighted.
I thought Conditional Formatting could do this but I don't see an option to keep these cells highlighted - this only gives an option to highlight cells that are 'yesterday' or 'last month' and when the dates go past 'yesterday' or 'last month' they get unhighlighted?!