|
|
#2
06-12-2017, 05:16 AM
|
||||
|
||||
Use Conditional Formatting....
Select the cell and go to Home|Conditional Formatting, New Rule. Select "format only cells that contain" in the Rules description area... Cell Value is >> Equal to >> =TODAY() Click Format and choose from Fill tab. Click Ok, click New Rule Select "use a formula to determine which cells to format" then enter: =AND(DATEDIF(A2,TODAY(),"m")>=6,DATEDIF(A2,TODAY() ,"m")<=12) where A2 contains the date... Click Format and choose from Fill tab. Click Ok, click New rule and repeat as above with Rule =DATEDIF(A2,TODAY(),"m")>12) 
|
| Thread Tools | |
| Display Modes | |
|
|
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 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 |
|
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 |
Windows 7 64bit 
Office 2007
Threaded Mode