highlight past date

Hi all

What i want to do is have a column of dates that are a few months away. But when we get past the dates entered i want those dates to automatically change to red to let me know that they are past due. Hope this makes sense.

Wendy:)

Select the dates.
Click Conditional Formatting on the Format menu.
In the dialog box:  Cell Value Is    less than    =Today()
Click the Format button and specify a format
'--
Jim Cone
Portland, Oregon USA
Special Sort add-in

Great thanks it works.

Your a legend

Hi Jim

It worked but then i realised it would only work for one cell. I didn't explain myself properly sorry. What i have is a row of different dates. I need to colour code the dates when the date isn't close i would like it to be green, when its nearly time for that date, i would like it to be yellow. Then when we have passed the date i would like it to show up red. These dates are a few months away. And i need to see straight away which date is upcoming and which date i missed.

In the conditions formatting dialog box is an "Add" button.
Enter a condition, press the Add button and repeat.
You can create up to 3 conditions.
And that seems to be what you are asking for...

Cell Value Is   greater than   =Today()+10                            (green)
Cell Value Is   between         =Today()  and   =Today()+10   (yellow)
Cell Value Is   less than        =Today()                                   (red)

Jim Cone
Portland, Oregon USA
My Excel Programs

Thanks it worked:)

Of course

Any idea on how to conditionally format a cell when the inputted date is greater than another date in Excel 2007?  I want to have the cell for the inputted date to highlight if greater than Jan 1, 2011.

the date 1 jan 2011 equates to 40544, the check will be if the date entered is GT than the integer value of 1 Jan 2011.

e.g if C4>40544,"XXX",""

The date entered can stay in the date format, as it is held as a number within excel.