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

Change the condition to Formula Is and use a formula of

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

--
HTH

Bob Phillips

"Mr. Smith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

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.



"Mr. Smith" wrote:
>
> 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

--

Dave Peterson