Forum Discussion
Conditional formatting for date that has past based on cell containing a formula
On Sheet2, select B8:B100 or however far down you want.
B2 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($A8<>"Complete", $B8<>"", $B8<TODAY())
Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.
On Sheet2, select B8:B100 or however far down you want.
B2 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($A8<>"Complete", $B8<>"", $B8<TODAY())
Click Format...
Activate the Fill tab.
Select red as highlight color.
Click OK, then click OK again.
- Thank you so much. That worked! I tried a few different options and couldn't get it to worth. You're a life saver!
