| I have a table with five different tasks (Columns). Each column has five rows. Each cell has start and end dates (i.e. 1/2/2013 and 1/10/2013). I would like the cell to automatically clear once the date is two months passed?|
OK, so we have two dates in Column B, Row 2 & 3 labeled Start & End, so your data looks something like:
1) Task One
2)Start Date 01/02/2013
3)End Date 01/10/2013
That way all I have to do is enter a new date and not have to go through each cell and delete the date.
Since I have used up what little VBA skills I have, instead of Deleting the contents,
how about we simply turn the Cell RED?
That should catch your attention, then you simply enter a new date, just type it in over the old date, no need to delete the contents.
Conditional Formatting 2007
1) Select your cell or range of cells: Select cell B3
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:
6) Click on the Format button
7) Select the Fill Tab
8) Select a RED color
9) Click OK
10) Click OK
See how that works for you.
message edited by mmcconaghy