Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-22-2014, 07:34 AM
gebobs gebobs is offline Conditional Formatting/If Statement with Dates Windows 7 64bit Conditional Formatting/If Statement with Dates Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Is this what you want? If so, check out the conditional formatting rules I set up. It will give you an idea of some of the ways you can set them up. And remember, rule precedence goes from top to bottom i.e. the first rule takes precedence over the second which takes precedence over the third, etc.
Attached Files
File Type: xlsx Test.xlsx (9.7 KB, 20 views)
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/If Statement with Dates 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 04:46 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