Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel 2007, creating a date based on another date, then formatting?
Can anyone tell me how to calculate a date in a new column based off another date in another column, then conditionally format it based off if it's a year later?
For example:
Say column D is: 5/5/12. Column E should be 5/5/13 (or 365 days later). Now, how do I format column E to be red once the date is over 365 days past column D? Then I need to apply this formula to all data in column E.
I've racked my brain on this, so any insight would be extremely helpful.
1 Answer
- garbo7441Lv 79 years agoFavorite Answer
You can use conditional formatting on column E. The following method is based on Excel2010, but should be the same (or similar) in Excel 2007.
Highlight all rows in column E that you wish to format. The following example assumes that the first cell is E1.
Select the Home tab and click the conditional formatting drop down in the Styles group.
Select 'New Rule'.
In the 'Select a rule type:' section, select 'Use a formula to determine which cells to format'.
In the 'Format values where this rule is true:' textbox, enter the formula:
=E1>DATE(YEAR(D1)+1,MONTH(D1),DAY(D1))
Click 'Format', select the 'Fill' tab, and select the color red you wish to use.
Click 'OK' twice.
