Conditional formating on text starts with "tot"

M

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
 
D

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.
 
Top