Coloring of Cells Between Dates

[eforti]

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

 

[Joe4]

Use Conditional Formatting, specifically the "FORMULA IS" option. If your first two dates are in cell A2 and B2, then the formula would look like this:

=AND($A2>=NOW(),$B2<=NOW())

 

[eforti]

Thank you for the response. Although this makes sense to me I can't seem to make it function. I have formulas in the cells to create the dates, so I figured that was screwing it up. Then I tried manually entering the data and it still didn't work. Any ideas?

 

[Joe4]

Can you tell me the EXACT cell range your dates fall into? Then I can try to give you step-by-step instructions.

 

[eforti]

I just figured out what was wrong. The less than and greater than signs are reversed.

Thank you again for your help.