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
Bookmarks