2007 conditional formatting begins with

[Lynn]

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

 

[Ron Rosenfeld]

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

It should be there.

Are you using the Ribbon?

If so, select

Home
Styles
Conditional Formatting
New Rule
Rule Type: Format only cells that contain
Rule Description
Format only cells with:
Specific Text (from dropdown)
beginning with (adjacent dropdown)
<enter your "c"
--ron