Results 1 to 2 of 2

Thread: Formula HELP

  1. #1

    Formula HELP



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need a formula that will automatically highlight a cell as well as write the word "RUSH" when a date is typed in that is within 2 weeks of the current date.

    Thank you!!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Assuming the dates start in A2, then in B2 enter formula:

    =IF(AND(A2-TODAY()>0,A2-TODAY()<=14),"RUSH","")

    For highlighting the cell, select the column. Go to Home|Conditional Formatting, then select Use a formula to determine which cells to format.

    Then enter formula: =$B1="RUSH" (where B1 is top most cell in column you selected and contains the above IF() formula)

    Click Format and choose colour from Fill tab.


Tags for this Thread

Posting Permissions

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