-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting- Dates greater than 6 months...
- Thread starter mjsel
- Start date
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Using that formula will highlight dates that are more recent than 180 days ago. If you want dates more than 180 days in the past try "less than or equal to" or use "formula is" with the formula
=DATEDIF(A1,TODAY(),"m")>=6
=DATEDIF(A1,TODAY(),"m")>=6
Upvote
0
lenze
Legend
- Joined
- Feb 18, 2002
- Messages
- 13,690
Hi and welcome to the board!!
Not sure what you really want, but it should be something like 1 of these
Conditional Formatting>Formula Is option
Note the use of mixed Absolute/Relative notations. This is so the formatting can be extended down Column "D" . Adjust as needed
lenze
Not sure what you really want, but it should be something like 1 of these
Conditional Formatting>Formula Is option
Code:
=($D1)*($D1<=Today()-180) or
=($D1)*($D1>=Today()-180)lenze
Upvote
0
advantagepro
New Member
- Joined
- Dec 22, 2013
- Messages
- 9
How would I accomplish this if I wanted to setup a formula that would show a color if the date from the D column was within the current year (2014), was last year (2013) or was in previous years or date ranges.
Upvote
0
