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