Forum Discussion
Solved
Date that will automatically highlight after 2 weeks
Hi, I have a spreadsheet with a column of dates that I would like to automatically highlight after 2 weeks. The date column is not sorted as my list is alphabetical according to the name column...
Yes. To illustrate I added current date as =TODAY() (now is Fri, Mar 12) and date two weeks before (Fri, Feb 26). All dates which are older will be highlighted
Norman_Harker , you forgot to exclude blank cells, and that's an opposite - in the range are dates in past. Highlighted are to be cells with more than two weeks old dates.
Agreed! Always unsafe to assume all cells have entries.
Similar on > rather than >=
That's why I prefer to set up the 'helper' column first and establish by TRUE and FALSE whether the conditional format formula will do what I want with the data that I have.
Only the user knows precisely what they want and have to cover for.
Regards and keep yourself, family and friends safe.
Norman
Similar on > rather than >=
That's why I prefer to set up the 'helper' column first and establish by TRUE and FALSE whether the conditional format formula will do what I want with the data that I have.
Only the user knows precisely what they want and have to cover for.
Regards and keep yourself, family and friends safe.
Norman