![]() |
#2
|
||||
|
||||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ophelias | Excel | 1 | 12-20-2016 07:13 PM |
![]() |
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 |
![]() |
CatMan | PowerPoint | 4 | 04-17-2012 03:29 PM |
![]() |
rterrain03 | Office | 5 | 12-01-2011 01:41 PM |