Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-25-2011, 02:54 PM
Frogggg Frogggg is offline Windows Vista Office 2007
Novice
 
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 Windows Vista Office 2007
Novice
 
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 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 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


All times are GMT -7. The time now is 08:25 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft