I'm trying to use the "begins with" function within conditional formatting in
2007, but the option is not there. Neither is there a contains option. I
tried using wildcards (eg. c* for words beginning with c) and this also did
not work.

Both Begins with and contains were available in 2003 - how can I acheive
this in 2007 please!?
Thanks