Excel

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

  1. Rob1234

    Rob1234 Megabyte Poster Forum Leader

    940
    127
    114
    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,292
    265
    329
    what he said
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  4. Rob1234

    Rob1234 Megabyte Poster Forum Leader

    940
    127
    114
    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 Forum Leader

    940
    127
    114
    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 Forum Leader

    940
    127
    114
    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...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.