Hi, I am trying to apply some conditional formatting to a certain column. Basically, if I type in a date that is greater than 18 months, I want it to turn red. It can stay normal if it's within that 18 month window and not past due.
For instance (everything is within column D),
Cell D4, I enter 2/12/2019 (this should highlight red)
Cell D5, I enter 8/22/2022 (this should stay unchanged/no color)
Please help! By the way, this is in Excel 365.
use a rule
=AND(D4<>"",D4<DATE(YEAR(TODAY()),MONTH(TODAY())-18,DAY(TODAY())))
IF the date is exactly 18mths - then
=AND(D4<>"",D4 < = DATE(YEAR(TODAY()),MONTH(TODAY())-18,DAY(TODAY())))
But you said greater than 18mth hence no =
for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting
Highlight applicable range >>
D4:D100 - Change, reduce or extend the rows to meet your data range of rows
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(D4<>"",D4<DATE(YEAR(TODAY()),MONTH(TODAY())-18,DAY(TODAY())))
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
Last edited by etaf; 08-24-2022 at 03:28 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks