Thread: [Solved] conditional Formating for dates greater than 3weeks or more
View Single Post
 
Old 07-31-2016, 01:08 AM
c991257 c991257 is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default
Try using formulas like this

=AND(A1-B1>=14;A1-B1<21)
=AND(A1-B1>=21;A1-B1<28)
=A1-B1>=28

That should do the trick.

/Møller
Reply With Quote