hello,
I need to know how to auto highlight dates.
I know how to highlight expired ones after current date but I need to know how to highlight ones after aparticular time.
For example I have the date 21/05/2015 and I need it to Auto highlight after 4 months.
Can someone please tell me if that's possible?
Use this formula for custom format:
=DATE(YEAR($A$1),MONTH($A$1)+4,DAY($A$1))
assumed your date on A1
Hello and welcome to the forum,
Using condition formatting with the following rule :
This will highlight any dates that are 4 months earlier or before.
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks