Dates in a worksheet

**Kevan M** · 10-16-2011, 05:24 PM

In a worksheet of diary dates I would like to link the dates to the footer date and when a worksheet date is overdue turn the cell red - possible?

**TMS** · 10-16-2011, 05:36 PM

What do you mean by "footer date"?

Regards

**Kevan M** · 10-16-2011, 05:53 PM

The current date - as shown by using the footer element - Thanks

**shg** · 10-16-2011, 05:57 PM

Kevan, I'll move your thread -- Tips and Tutorials is not a question forum.

Please take a few minutes to read the forum rules before posting again.

**TMS** · 10-16-2011, 06:08 PM

Assuming the dates are in column A, starting in row 2, select all the cells you want to highlight.

Select Conditional Formatting and choose the condition: Formula: =$A2<TODAY() then choose the format you want to apply. Note that the cell address will adjust automatically.

Regards

**Kevan M** · 10-17-2011, 06:35 PM

Right that works thanks- I can get Red Amber Green the dates for overdue, today and future by using <,=,> Today in the condition fields. I now want to extend the Amber from "Today" to "Today + 31 days" but cannot get it working. How do I change the 2nd & 3rd conditions fields? And is it "cell value is" or "formula is"? Thanks

**TMS** · 10-18-2011, 04:02 AM

You use Formula is and it is TODAY()+31 ... the brackets indicate a function with no parameters. No idea why it's done like that but the brackets are necessary.

Regards