conditional formatting 2007 - begins with
Hi Dave,
you are right I answered based on 2007
"Dave Peterson" wrote:
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
Lynn wrote:
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?
--
Dave Peterson
|