identification of cell that exceed certain number of characters
Thank you
-----Original Message-----
Todd,
conditional formatting.
Use a condition of IsFormula, and a formula of =LEN(A1)
6, and just choose a
format to suit. This assumes A1 is the first cell you
want to format, and
the length you want is 6.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Todd" wrote in
message
...
I would like to identify cells in a column that have
more
then a certain number of characters in them because I
need
to trim them down so fit on a mail merge lable.
We can go with color coding - which would be great or in
required I can have a new field that an x appears when
my
target field has to many characters in it.
The color coding of the cell would be great.
Thanks Todd
.
|