conditional formatting 2007 - begins with

[Lynn]

I am trying to pick out data that "begins with" a certain letter. In Office
2003, Conditional formatting had this option. I could also have used
"contains" or even a wildcard, but "contains" is not available, and wildcards
do not appear to work.

Can anyone help?

 

[Eduardo]

Hi Lynn,
Ok if you want to highlight a cell, go to Conditional formating,Highlight
cell rules, text that contains

if this helps please click yes, thanks

 

[Dave Peterson]

You're misremembering xl2003.

"Begins with" isn't in conditional formatting in xl2003. (You're thinking of
the Custom choice in data|filter|autofilter.)

But you could use a formula:
=left(a1,1)="x"
to check for a leading X (or lower case x) in A1

 

[Eduardo]

Hi Dave,
you are right I answered based on 2007

You're misremembering xl2003.

"Begins with" isn't in conditional formatting in xl2003. (You're thinking of
the Custom choice in data|filter|autofilter.)

But you could use a formula:
=left(a1,1)="x"
to check for a leading X (or lower case x) in A1