Hi Ben,

conditional formatting:-

Assuming cell A1 is the first cell to format then select A1 then select
conditional formatting and in conditional formatting select the formula
option.

In the box insert this formula:-

= A1<today()

Then select the type of formatting required.

Copy the cell and Paste Special- Formats to other cells where you require it.

Regards,

OssieMac

"Ben" wrote:

For example (lets say all cells have black text):
06 Aug 2007
07 Aug 2007
08 Aug 2007

If today is 06 Aug 2007, nothing happens, all cells have black text. Go to
sleep... now its 07 Aug 2007.

Is there a way to cross/tick off the previous days automatically with a
formula or conditional format? I want to make the text turn to red, eg. in
our above example 06 Aug 2007 should now turn red because we are now 07 Aug
2007.

Thanks in advance for some replies!! (I hope)