Results 1 to 2 of 2

Thread: Cell formula to change text based on date

  1. #1

    Cell formula to change text based on date



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

    Hi,


    I need a formula that will turn the text in a cell red after a certain number of weeks from the date entered in the cell. For example if I enter the date 15/10/14, after 10 weeks I need it to turn red.




    Any help appreciated!


    Excel 2007


    Thanks.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try conditional format rule formula:

    =TODAY()>=$A1+70

    where A1 is topmost cell in your selection.


Posting Permissions

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