+ Reply to Thread
Results 1 to 3 of 3

Looking to Select a date and have all Cells 90 days before that date turn red

  1. #1
    Registered User
    Join Date
    06-05-2018
    Location
    Missouri
    MS-Off Ver
    2013
    Posts
    11

    Looking to Select a date and have all Cells 90 days before that date turn red

    Hello,

    I am working on a spreadsheet where my Co-Worker would like to enter in a date such as 3/22/19 and have all the dates that are 90 days prior to that date or greater Turn red. I know i can just do a conditional format for this but i am trying to have it so she can change the date on the fly.

    I have attached a sample spreadsheet.

    I would Like Cell A1 be where the date is to be entered and then Columns 2, 3 and 4 be the dates that would be searched through to find dates that are 90+ days prior to the date entered in Cell A1.

    Thank you for all your help.
    Attached Files Attached Files
    Last edited by Broberts1986; 03-22-2019 at 08:22 PM. Reason: Forgot to attach Example

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Looking to Select a date and have all Cells 90 days before that date turn red

    You still need a conditional format for this, try the formula below as the rule.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-05-2018
    Location
    Missouri
    MS-Off Ver
    2013
    Posts
    11

    Re: Looking to Select a date and have all Cells 90 days before that date turn red

    Well Thank you very much that was quick and easy thank you yet 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. Need a formula for "Days Open" with a Turn In Date and Date Closed
    By jinthesensei in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2018, 11:31 PM
  2. Pass the last business days date through odbc to "select where date >= the date"
    By MostHated in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2015, 04:15 PM
  3. update date to 10 days after another cells date
    By tabford in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-19-2015, 07:23 PM
  4. Replies: 1
    Last Post: 10-02-2012, 02:42 PM
  5. how will cell vaule turn red 5 days after the date entered
    By Mrs.Z in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-30-2011, 04:31 AM
  6. Replies: 1
    Last Post: 07-30-2010, 03:35 PM
  7. [SOLVED] Need a formula that will turn a date red if that over 60 days
    By Holly in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2006, 05:40 PM

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