Hello,
[IMG]http://i44.tinypic.com/2icb5o5.jpg[/IMG]
I need to check the cells E throughout for:
if the cell contains date older than 2 weeks (today - 14 days)
then delete entire row.
if the cell contains date within 10 weeks (today + 70 days)
then mark cell green.
if the cell doesn't contain any date
then next cell.
I thought i could solve this via conditional formatting but that deleting can only be done by VBA. I need help from you guys.
[IMG]http://i44.tinypic.com/2icb5o5.jpg[/IMG]
I need to check the cells E throughout for:
if the cell contains date older than 2 weeks (today - 14 days)
then delete entire row.
if the cell contains date within 10 weeks (today + 70 days)
then mark cell green.
if the cell doesn't contain any date
then next cell.
I thought i could solve this via conditional formatting but that deleting can only be done by VBA. I need help from you guys.