Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Expired Dates (https://www.askmehelpdesk.com/showthread.php?t=50005)

  • Dec 22, 2006, 09:37 AM
    thdan74
    Expired Dates
    I have a training spreadsheet in excel. I would like to know how to highlight a date if the dates has expired one year from today's date. Is there a way to do that?
  • Dec 22, 2006, 09:41 AM
    cajalat
    You can use "Conditional Formatting" to highlight the cell based on a given condition. Conditional Formatting is found under the Format menu.
  • Dec 22, 2006, 09:47 AM
    ScottGem
    The Condtion you would want would be something like:

    Today() > A1+365
  • Jan 30, 2007, 12:01 PM
    FirstKnight
    Also make sure that the Condition 1 box says "Formula is" and you will need a "=" before the formula begins, so excel does not treat your formula as a string!

  • All times are GMT -7. The time now is 10:11 AM.