conditional formatting 2007 - begins with

  • Thread starter Thread starter Lynn
  • Start date Start date
L

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?
 
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
 
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
 
Hi Dave,
you are right I answered based on 2007

Dave Peterson said:
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
Click to expand...
 
Back
Top