You may want to use Format|Conditional formatting (in xl2003 menus).

Select the range (A2:A999)
format|conditional formatting
formula is:
=len(a2)40

and give it a nice format.

wrote:

Hello,

Can somebody please provide me with a loop function which will color
the datafield in a red color if the number of characters is more then
40.
This function is needed to loop only through the first column of the
sheet from record 2 till last.

Hopely you can help me out.

regards,
Johan

--

Dave Peterson