Hello All,
I have two columns with dates in them. They go in an order where the lower you go in the sheet the further out the date is. Each row is a task. I'd like to highlight the two dates that today's date falls between.
Ex:
Column 1......Column 2......Column 3
Task1.............9/1/07...........9/5/07
Task2.............9/8/07...........9/19/07
Task3.............9/24/07.........10/13/07
If todays date is 9/17/07 I'd like to highlight the cells with 9/8/07 and 9/19/07 in them because todays date is between them. Is this something that can be accomplished with conditions? Or do I need VB?
Thanks in advance
I have two columns with dates in them. They go in an order where the lower you go in the sheet the further out the date is. Each row is a task. I'd like to highlight the two dates that today's date falls between.
Ex:
Column 1......Column 2......Column 3
Task1.............9/1/07...........9/5/07
Task2.............9/8/07...........9/19/07
Task3.............9/24/07.........10/13/07
If todays date is 9/17/07 I'd like to highlight the cells with 9/8/07 and 9/19/07 in them because todays date is between them. Is this something that can be accomplished with conditions? Or do I need VB?
Thanks in advance