Thread: Conditional formatting on Current or previous Quarter entries
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Loadmaster Loadmaster is offline
external usenet poster
  
Posts: 82
Default Conditional formatting on Current or previous Quarter entries
I want to format cell A1 to turn red if the date in cell A1 is not within the
current or previous quarter date specified in cell B2 with:
=DATE(YEAR(TODAY()),INDEX({3;6;9;12},INT((MONTH(TO DAY())+2)/3))+1,0)
Reply With QuoteReply With Quote