View Single Post
 
Old 06-30-2017, 10:43 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 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