Thread: Conditional Highlighting When Approaching End of Quarter if Date in Cell is From Previous Quarter
View Single Post
 
Old 12-06-2019, 04:25 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 869
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
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)))
Reply With Quote