Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter

12-06-2019, 04:25 AM

p45cal

Windows 10 Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

try:

Code:

=AND(TODAY()>EOMONTH(TODAY(),MOD(3-MONTH(TODAY()),3))-45,OR(LEN(TRIM($H6))=0,$H6<DATE(YEAR(TODAY()),FLOOR(MONTH(TODAY())-1,3)+1,1)))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditionally Highlighting Blank Cells by Quarter in Current Calendar Year	PrincessApril	Excel	2	11-29-2019 03:31 AM
Microsoft word Page has 4 quarter squares on each paper	AZn	Word	3	05-18-2017 07:50 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Group Date by Quarter in PIVOT TABLE	shilabrow	Excel	6	04-24-2014 10:44 AM
Conditional Mail Merge per Student and Quarter	marysilvaramos	Mail Merge	1	01-29-2013 07:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 PM.