|
|
#2
06-22-2017, 02:32 AM
|
|||
|
|||
Is it 17-22 years or days?
When days, then (2 conditional formats, let's assume the date you are checking is in column A, the 1st data row is 2): Select the range you want the conditional formats apply to (a single column in your table, several columns, or the whole table - minus header(s)). Open Conditional formatting, apply 2 condition formulas and according formats. 1. =AND(($A2-17)>=TODAY();($A2-22)<=TODAY()) 2. =AND(($A2+30)>=TODAY();($A2)<=TODAY()) 
|
|
|
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 |
 Find if Date range falls within another range
|
Triadragon | Excel | 3 | 05-02-2016 11:48 AM |
| Conditional Formatting a Range | Phil H | Excel | 3 | 02-17-2016 08:33 AM |
| Check if a Date falls within a date range | OTPM | Excel | 7 | 02-03-2016 09:11 PM |
|
critical activity with floating end date
|
ketanco | Project | 7 | 06-17-2014 10:17 AM |
Windows 8 
Office 2016
Threaded Mode