Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2017, 05:39 AM
NBVC's Avatar
NBVC NBVC is offline Date changes colour with age Windows 10 Date changes colour with age Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Hi,

Sorry have been away for a few days...



For me it works.

The only change I would recommend is with the first formula... instead of just =TODAY(), use formula: =AND(A2<=TODAY(),DATEDIF(A2,TODAY(),"m")<6) this will keep it green until 6 months old...
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Project 2016 print specific date range stuck on one date martinsalmon Project 1 10-12-2016 11:36 AM
Date changes colour with age Date picker content control to always show current date. lucky16 Word VBA 2 07-01-2016 01:14 PM
Project 2013 - Change GANTT Bar Colour By Main Task Date CaelanT Project 1 02-09-2015 12:50 PM
Date changes colour with age How can a document have the same date modified/create date, yes have have actual file content? legaleagle Word 15 01-07-2015 06:58 PM
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft