Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2014, 06:06 AM
Phil H Phil H is offline Conditional Formatting Dates Windows XP Conditional Formatting Dates Office 2003
Advanced Beginner
Conditional Formatting Dates
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default

SOLUTION: =$N5<=DATE(YEAR($C$2-3),MONTH($C$2),DAY($C$2)). The "-3" is interpreted as days in the YEAR expression. If "-3" is replaced with "1097", the formula works.
Reply With Quote
Reply

Tags
conditional formatting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting/If Statement with Dates AndrewEnos Excel 2 07-22-2014 07:34 AM
Conditional Formatting - color only dates contained in a range EC37 Excel 1 07-08-2014 12:51 PM
Conditional Formatting Dates Conditional Formatting - past due dates namedujour Excel 1 06-27-2014 04:16 PM
Conditional Formatting with Dates namedujour Excel 1 02-21-2013 03:42 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:32 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