Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-30-2017, 10:43 AM
NBVC's Avatar
NBVC NBVC is offline Identify when a date is to expire Windows 10 Identify when a date is to expire 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

You can use conditional formatting to colour the cells accordingly.

Assuming your dates are in column A beginning at A2, then select the range from A2 to bottom of range and go to Home|Conditional Formatting|New Rule.

Select "use a formula to determine which cells to format" then enter formula:

=DATEDIF($A2,TODAY(),"m")>=23


Click Format and choose from the Fill tab.

Click Ok, then New Rule and repeat with formula

=DATEDIF($A2,TODAY(),"m")>=11

and again with formula

=DATEDIF($A2,TODAY(),"m")>=5

Make sure the formula are displayed in the above order (you can move each up or down with the arrow tools), then check the "Stop if True" checkboxes in the last column.

Last edited by NBVC; 06-30-2017 at 11:46 AM. Reason: typo
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Identify when a date is to expire Identify Purchasers who bought products on the same date ophelias Excel 1 12-20-2016 07:13 PM
Identify when a date is to expire Please help me Identify this font!!! PLEASE!!! krammkracker Word 1 10-13-2015 12:06 PM
VBA to identify how Word was invoked Sorcerer13 Word VBA 7 04-24-2014 11:15 AM
Identify when a date is to expire How do you identify the ID of a picture in PowerPoint? CatMan PowerPoint 4 04-17-2012 03:29 PM
Identify when a date is to expire identify non-members from two lists rterrain03 Office 5 12-01-2011 01:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:05 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