Aug 9, 2023
Conditional formatting for a date being 30, 90, 183 days out from today
The dates are in column B and this is what I've tried:
- apply to range B2:B100
- selected "format cells if less than or equal to"
- The formula I have been trying is: =B2>TODAY()-90
- select green, yellow, or red based on the formula rule
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Hi, DaniC.,
You almost had it! You can use the following conditional formatting rule for this:
Apply To Range: B2:B
Format Cells If: Less than or equal to
Custom Formula Is:
=TODAY()+30Formatting Style: Dealer's choice
The above rule will work for anything that is 30 or less days after today. For other timeframes, just change the "30" in the formula.
Hope this helps!
--
When you've received a response that answers your question, please observe these forum courtesies:
• Leave your demo sheet shared as part of this solution's archive
• Click 'Recommend' on the reply that best addressed your question
• Post again soon!
Last edited Aug 9, 2023
Original Poster DaniC. marked this as an answer
All Replies
Aug 9, 2023
Hi, DaniC.,
You almost had it! You can use the following conditional formatting rule for this:
Apply To Range: B2:B
Format Cells If: Less than or equal to
Custom Formula Is:
=TODAY()+30Formatting Style: Dealer's choice
The above rule will work for anything that is 30 or less days after today. For other timeframes, just change the "30" in the formula.
Hope this helps!
--
When you've received a response that answers your question, please observe these forum courtesies:
• Leave your demo sheet shared as part of this solution's archive
• Click 'Recommend' on the reply that best addressed your question
• Post again soon!
Last edited Aug 9, 2023
Original Poster DaniC. marked this as an answer