Conditional Formatting based on 2 criteria

Hi There

Wonder if someone can help me on this. I have an Excel sheet on which I want to create a conditional format that only activates if both criteria are met.

I have some dates in Column B, and the first criteria needs to be anything that is 14 days less than todays date. (I have managed to do a singlue condition which is Cell Value is "Less than" TODAY()-14 for this). I still want that to be the case, but I also want it to look at column P and look for anything with a status of "Open".

If both items are true, I then want the formatting to change.

I was trying to use the AND( function for this, but I just can't seem to get it right.

Any help would be much appreciated.

Select all of the cells B2 down, change the CF from a cell value to Using formula, and use the formula

=AND(B5<TODAY()-14,P5="Open")

Brilliant .. works a treat. Thankyou.