I'm using Excel 2007 and I would like conditionally format a cell based on 2 other cells.

I currently have it based on one cell.

I'm in "Use cell to determine which cells to format" under conditonally format. The formula I have in there is:

=$M7<TODAY()

That formula applies to =$A$7:$R$105

Works PERFECT...except

I only want it to do that format if cell $L7 says "In-Transit"

So I need to alter =$M7<TODAY() somehow to make it look at 2 cells