+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting of rows that are 90 days within end date

  1. #1
    Registered User
    Join Date
    08-04-2022
    Location
    Florida
    MS-Off Ver
    MS Office 365 Apps for enterprise
    Posts
    11

    Question Conditional formatting of rows that are 90 days within end date

    Hi All,

    I'm trying to figure out how to highlight a row when the current date falls within 90 days before the end of a contract end date.

    For example:

    Current End Date: 12/1/22
    90 Days before End Date: 9/2/22
    If todays date falls within this window, I want the row to highlight a red.

    I created a column with todays date, a column that calculates the date 90 days prior, and the actual end date and tried the Conditional Formatting > Highlight Cell Rules > Between with no success.
    Not sure if I'm making it too complicated, but thats a result of me being green.
    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Conditional formatting of rows that are 90 days within end date

    Delete the current date column and put the current date outside of the table.
    Use cond. format:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-04-2022
    Location
    Florida
    MS-Off Ver
    MS Office 365 Apps for enterprise
    Posts
    11

    Re: Conditional formatting of rows that are 90 days within end date

    Thank you so very much for your help. Worked perfectly. I didnt try the AND option.. Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 02-21-2020, 08:35 AM
  2. Conditional formatting where date - 90 days <= todays date
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2020, 03:58 AM
  3. conditional formatting date by 2 days
    By melissaoi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2017, 07:57 AM
  4. Conditional Formatting - Date is within 30 days
    By BlessedPsycho in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2016, 11:24 AM
  5. Conditional Formatting when 2 days before Current Date
    By wmfinance in forum Excel General
    Replies: 2
    Last Post: 08-09-2010, 01:39 PM
  6. Conditional Formatting date more than 5 days old
    By speakers_86 in forum Excel General
    Replies: 11
    Last Post: 05-22-2007, 01:08 PM
  7. [SOLVED] Conditional formatting based on a date + 30 days
    By Laura4363 in forum Excel General
    Replies: 5
    Last Post: 01-13-2006, 07:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1