Thanks, it now does exactly what I need it to do. You guys are soooo
helpful!!


"T. Valko" wrote in message
...
Make the 3rd condition the 1st condition. The conditions have precedence
in the order in which they are entered.

--
Biff
Microsoft Excel MVP


"Ben" wrote in message
...
Oh... one step further.

What you guys helped me with is the 3rd condition (again Thanks!). The
first 2 are also set to change the colour of the text, ie: 1st Cond -
turns text red if a predetermined cell has a 'T' in it, 2nd Cond - turns
text blue when 'R' is inserted. Can something be done to make this
condition (3rd) override the first two regardless of whether they hold
true or not?


"Ben" wrote in message
...
Thanks for the quick reply and excellent advice. It is perfect!

So I can learn to understand it. I know what '=A1' is for but can you
please tell me what the '<' and '()' are mean?



"Joerg Mochikun" wrote in message
...
That's what the conditional format is made for.
Assuming that the date is in A1, choose as condition1 "Formula is" and
input =A1<TODAY()

Now select the format for this condition (e.g. red text).

Copy/paste this formula to all your other cells containing dates
(easily done with the format painter)

Cheers,

Joerg Mochikun



"Ben" wrote in message
...
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)