Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-18-2022, 04:11 AM
ArviLaanemets ArviLaanemets is offline Date Conditional Formatting Windows 8 Date Conditional Formatting Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by stu_c View Post
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)
Reply With Quote
 



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
Date Conditional Formatting Conditional Formatting based on dynamic Date Modifier1000 Excel 2 09-12-2014 08:53 AM
Date Conditional Formatting Date Conditional Formatting teza2k06 Excel 1 08-09-2014 09:58 AM
Date Conditional Formatting Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft