Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-25-2011, 02:54 PM
Frogggg Frogggg is offline Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Windows Vista Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Office 2007
Novice
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell
 
Join Date: Aug 2010
Posts: 10
Frogggg is on a distinguished road
Default Conditional Formatting Expiration Dates Based on Text in Adjacent Cell

Hi all,
using conditional formatting I want my expiration dates to highlight red based on text criteria in an adjacent column.



If E4="Low" or "Moderate" then D4 should turn red if the date is more than 3 years old. For the second part of the formula I had =TODAY()>=DATE(YEAR(D5)+3,MONTH(D5),DAY(D5))

If E4="High" or "Critical" then D4 should turn red if the date is more than 1 year old.

I just don't know how to bring all of the elements together.

all help is appreciated.
Reply With Quote
  #2  
Old 10-25-2011, 08:44 PM
Frogggg Frogggg is offline Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Windows Vista Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Office 2007
Novice
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell
 
Join Date: Aug 2010
Posts: 10
Frogggg is on a distinguished road
Default

don't worry I worked it out with a lot of help from another forum
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Conditional color fill based on presence of data avanderh Excel 11 07-28-2011 09:10 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Conditional formatting of cell, Excel 2003 Scaffold Excel 2 05-01-2010 08:56 AM
Finding the difference of two dates based on criterion. aligahk06 Excel 0 04-27-2010 12:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:37 PM.


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