conditional Formating for dates greater than 3weeks or more

		Microsoft Office Forums > Microsoft Excel > Excel
conditional Formating for dates greater than 3weeks or more

07-31-2016, 01:08 AM

c991257

Windows 10 conditional Formating for dates greater than 3weeks or more

Office 2016

Advanced Beginner

Join Date: Mar 2014

Location: Zambia

Posts: 61

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formating	Aseren	Excel	14	02-18-2016 01:05 PM
Copying Conditional Formating	lynette	Excel	2	03-06-2015 11:53 AM
Conditional Formating	MaineLady	Excel	1	11-05-2014 06:37 PM
Conditional Formatting with Dates	namedujour	Excel	1	02-21-2013 03:42 AM
more Conditional Formating	princeofsadness	Excel	2	09-05-2011 02:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:42 AM.