Tina - works a treat - thank you.

OK, one step further. Can I use conditional formatting to turn the
background from red to green is there is a * in B10 - or is this sort of
multiple formats too much for it (using Excel97)

--
Tobit

"tina" wrote in message
...
Hi
Try
=AND((TODAY()-B3)0,B10<"*")
Tina
"TC" wrote:

I have a conditional formatting warning on some cells so that if the date
in
B3 is older than today the background goes red

Formula is = (TODAY()-B3)0

How would I write this so that the action is to go red unless there is a
*
on cell B10 ?

Thanks

--
Tobit