...another quick excel formula question!

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?!
 
....actually - yes, that worked!!!

Thanks.
:smashin:
 

The latest video from AVForums

TV Buying Guide - Which TV Is Best For You?
Subscribe to our YouTube channel
Back
Top Bottom