Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Flaging Dates with Conditional Formatting (Excell 2000)

    Hey folks,

    What I would like to do is have a date flagged between two dates, if it falls short of 15 days from the current day (I am using if to show that a request takes 2 weeks in advance, and when someone does not meet this requirement, the date they made the request will show up in red).

    Does anyone know how I can get these dates to do this?

    Thanks

    Semper Fidelis,

    Clinton

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Flaging Dates with Conditional Formatting (Excell 2000)

    Something like th efollowing using a Formula based condidtion :

    Formula Is : =TODAY() - A1 > 15

    for a date in A1.

    see attached

    Andrew C
    Attached Images Attached Images

  3. #3
    New Lounger
    Join Date
    Nov 2002
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Flaging Dates with Conditional Formatting (Excell 2000)

    Thank you very much!

    We had to do a little tweaking to the formula because the requirements changed on us a little... Heres the result:

    =A1>TODAY()+15

    Thank you again for your help!

    Semper Fidelis,

    Clinton

Posting Permissions

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