View Single Post
 
Old 06-22-2017, 02:32 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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())
Reply With Quote