David,
I actually need the formula to update column D, does the formula need to
cahnge any?
--
JPS


"David Biddulph" wrote:

Gary's formula in CF will do that.
If you want also to deal with "tbn" in lower case, change his CF formula to
=LEN(SUBSTITUTE(UPPER(A1),"TBN",""))<LEN(A1)
--
David Biddulph

"JPS" wrote in message
...
If TBN is found anywhere within the text of a cell, I need the color of
the
font for all of the text in that cell to be green.

"Gary''s Student" wrote:

Say for cell A1, use Formula Is:

=LEN(SUBSTITUTE(A1,"TBN",""))<LEN(A1)

"JPS" wrote:

How do I change the color of a cell to green if the cell contains the
phrase
"TBN" anywhere within the text