@rkjacks09
Select O2:O100 or as far down as you want.
O2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($O2<>"", $O2<=TODAY()-7, $P2="")
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
