formula help for conditional formatting

Topic

New Reply

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

Reply | Quote

Replies

Hi Capri

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

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

Reply | Quote

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

Hi Capri

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

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

Reply | Quote