Date Conditional Formatting

ArviLaanemets · #4 05-18-2022, 04:11 AM

Quote:

Originally Posted by stu_c

I am guessing if I wanted a conditional format after 6 months would it be
=DATE(YEAR(B4) + B$2, MONTH(B4), DAY(B4))<TODAY()-182

OR
the 4 conditional format formulas may be
=(DATE(YEAR(B4) + B$2, MONTH(B4)-12, DAY(B4))<TODAY())
=(DATE(YEAR(B4) + B$2, MONTH(B4)-6, DAY(B4))<TODAY())
=(DATE(YEAR(B4) + B$2, MONTH(B4)-3, DAY(B4))<TODAY())
=(DATE(YEAR(B4) + B$2, MONTH(B4)-1, DAY(B4))<TODAY())
(And you have to combine the order of formulas, and StopIfTrue, to get right colors used)

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 formatting a row based on date	cwkotch	Excel	1	08-28-2021 10:14 PM
Conditional Formatting based on date	teza2k06	Excel	2	11-27-2018 09:55 AM
Conditional Formatting based on dynamic Date	Modifier1000	Excel	2	09-12-2014 08:53 AM
Date Conditional Formatting	teza2k06	Excel	1	08-09-2014 09:58 AM
Conditional formatting question based on cell date	Cosmo	Excel	2	04-08-2013 12:12 PM