Ask Experts Questions for FREE Help !
Ask
    thdan74's Avatar
    thdan74 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 22, 2006, 09:37 AM
    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?
    cajalat's Avatar
    cajalat Posts: 469, Reputation: 66
    Full Member
    		  
    #2

    Dec 22, 2006, 09:41 AM
    You can use "Conditional Formatting" to highlight the cell based on a given condition. Conditional Formatting is found under the Format menu.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Dec 22, 2006, 09:47 AM
    The Condtion you would want would be something like:

    Today() > A1+365
    FirstKnight's Avatar
    FirstKnight Posts: 5, Reputation: 1
    New Member
    		  
    #4

    Jan 30, 2007, 12:01 PM
    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!
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Expired 10 year green card [ 1 Answers ]

I know someone who has an expired green card. She has already applied for a new one and sent the money for it. How long does it take now to renew this card? Can she get a job with the expired green card and the letter from the government where it says that they received the money to process her...

Can you have two wedding dates? [ 24 Answers ]

This seems like a silly question but I've been struggling with my (insane!) future in-laws for a while now. I'm getting married in July to a man I love and want to spend the rest of my life with, but his parents have gone completely bonkers over the wedding. They are of a different faith than I,...

Expired RE agent contract? [ 1 Answers ]

A real estate agent has a standard 3 months contract with a seller, with a reserve for all potential buyers for 90 days after expiration of contract. Agent secures a buyer within the initial 90 days, but problems on part of buyer delays closing for 7 months. When closing takes place, it is more...

View more questions Search