Conditional Formatting
Pete, a major benefit with the way JE McGimpsey has laid out the formula, is
you don't need to have a cell with Today() in it, thats just something I do,
as I tend to refer other cells to one throughout my worksheets, and give me
one reference to change for testing etc.
If you want to remove it, just modify the formulas too;
Condition 1
=IF(AND(B2<Today(),C2="",B2<""),TRUE)
Condition 2
=IF(AND(OR(B2=Today(),B2<=Today()+7),C2="",B2<"") ,TRUE)
Should work as required.
--
This post was created using recycled electrons!
|