Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi,

    I'm trying to help someone with a file tracking system and can't seem to get the formula correct for the conditional formatting
    The date the file comes into the office is in column L. Column M contains either a Y or N to indicate whether the file has left the office. Column N contained the formula "=(NOW()-L997)". This gives the number of days since the file came into the office.

    I only want the number to show in column N if the entry in column M is "N". (meaning the file has not left the office) and if the number of days the file has been in the office is 14 or greater.

    Is there a formula that I could put in the conditional formula that would highlight the cell in the specified manner if it met

    The value of M997 is N and the value of N997 is 14 or greater?

    I want to place the conditional formatting on cell N997 but don't know how to combine a formula for the IF M997=N and the cell value for N997 being 14 or greater.


    Thanks for any help
    capri

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi Capri

    Does this do the job? Just place column N and copy down:

    =IF(AND(NOW()-L2>=14,M2="N"),NOW()-L2,"")
    Jerry

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks Jezza,

    It works great. I'll have to figure out how the IF(AND part works so I can use it in future.

    capri



    [quote name='Jezza' post='766350' date='20-Mar-2009 10:05']Hi Capri

    Does this do the job? Just place column N and copy down:

    =IF(AND(NOW()-L2>=14,M2="N"),NOW()-L2,"")[/quote]

Posting Permissions

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