Hi, I'm trying to add colour in column E5, yellow after 34 months from the date in D5 and then red in the same E5 after 36 months. Is it possible?
Then if the date in D5 is updated, I want E5 to become white again.
Hi, I'm trying to add colour in column E5, yellow after 34 months from the date in D5 and then red in the same E5 after 36 months. Is it possible?
Then if the date in D5 is updated, I want E5 to become white again.
CF#1 for red move to top of list and check "stop if true":
#2, yellow: do not check "stop if true"![]()
=DATEDIF(D5,$F$2,"m")>=36
![]()
=DATEDIF(D5,$F$2,"m")>33
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks