View Single Post
  #1   Report Post  
TC
 
Posts: n/a
Default conditional format

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