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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:20 AM.