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