1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel

Discussion in 'Software' started by Rob1234, Oct 13, 2007.

  1. Rob1234

    Rob1234 Megabyte Poster

    782
    24
    69
    I am trying to create an IF statement that highlights the information in red if it is past or near a certain date. Does anyone know how to do this?

    for e.g.

    Hardware Date

    Hard drive 15 June 2008
    Monitor 14 October 2007

    so the monitor data should be highlighted in red as it is getting close to the current date.
     
    Certifications: A few.
  2. ManicD

    ManicD Byte Poster

    237
    4
    34
    Dont write it as an if statement, select the cell and goto>format>conditional formating
     
    Certifications: MCSA, N+, A+(Tech), ECDL
    WIP: 70-294, 70-298
  3. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,283
    254
    329
    what he said
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  4. Rob1234

    Rob1234 Megabyte Poster

    782
    24
    69
    I looked at doing it that way but im not really sure how to as it asks for things like a value greater then or between etc. but how do I make it so the conditional value is a date?
     
    Certifications: A few.
  5. ManicD

    ManicD Byte Poster

    237
    4
    34

    select greater than, or between or whatever and write a date in the value box, set the formatting, and it works fine.


    I just formed a list and bolded every date "greater than" "5/5/05"

    it worked fine, in excel 2002.
     
    Certifications: MCSA, N+, A+(Tech), ECDL
    WIP: 70-294, 70-298
  6. Rob1234

    Rob1234 Megabyte Poster

    782
    24
    69
    I see what you mean but I want to put the current date so that it will automatically keep things up to date if I type in 13/10/07 it will be out of date by tomorrow. Is there a way to put a formula in so the date will adjust every day?
     
    Certifications: A few.
  7. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    Just use =TODAY() as your value to compare against
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  8. Rob1234

    Rob1234 Megabyte Poster

    782
    24
    69
    That worked the exact formula I used was

    =AND(B4-TODAY()>=0,B4-TODAY()<=30)

    Thanks for the help.:biggrin
     
    Certifications: A few.

Share This Page

Loading...