What I'm trying to is when the sheet activates to run a check on a range E2:E(last cell). So if the date is past a certain time frame (3 to 7 days) color background yellow, and if the date is past 7 to 365 days color back ground red. the Vb code i have works but only if you enter a date in the cell and change it contents. so here is what i have so far. please help my brain is fried. 

Please Login or Register  to view this content.
Thank you

V/R
Patrick