Thread: formula help for conditional formatting

1. 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. Hi Capri

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

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

3. 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
•