Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-21-2014, 12:56 PM
AndrewEnos AndrewEnos is offline Conditional Formatting/If Statement with Dates Windows 8 Conditional Formatting/If Statement with Dates Office 2013
Novice
Conditional Formatting/If Statement with Dates
 
Join Date: Jul 2014
Posts: 1
AndrewEnos is on a distinguished road
Default Conditional Formatting/If Statement with Dates

I am creating a construction punch list with 5 columns, two of the columns are DUE DATES and COMPLETED DATES. I am trying to get the Due Date cells to turn red once the date entered has passed and as long as there is no date entered into the Completed dated cell. I am also trying to have the completed date cell turn green once a completed date is entered and have the due date column to turn back white. Is this possible?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting - color only dates contained in a range EC37 Excel 1 07-08-2014 12:51 PM
Conditional Formatting/If Statement with Dates Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting - past due dates namedujour Excel 1 06-27-2014 04:16 PM
Conditional Formatting/If Statement with Dates 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 02:23 PM.


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