Conditional formating on text starts with "tot"

[Mr. Smith]

Hi.
Is it possible to set conditional formating in all cells which starts with
"Tot.", as in "Tot. Product 1", "Tot. Product 2". I only find number
statements in the Conditional formating dialoge and not "If cell begins
with....."

Any ideas?

Mr. Smith

 

[Bob Phillips]

Change the condition to Formula Is and use a formula of

=LEFT(A1,4)="Tot."

 

[Dave Peterson]

Another option...
=countif(a1,"tot.*")>0
(with A1 the cell getting the format|conditional formatting.)

What's nice about this style is you can look for the string anywhere in the
cell:

=countif(a1,"*duct*")>0
will look for duct anywhere in A1

=countif(a1,"* 1")>0
will look for for the final 2 characters of A1 as spacebar, one.