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

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

Why don't you use conditional formatting? Select range, say, from A2 to last
row, FormatConditional formattingChoose formula as condition and enter
=LEN(A2)40
in the formula field and choose red pattern!


Regards,
Stefi

€� ezt Ã*rta:

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

Thanks all.
Very simple and works fine.

regrds,
Johan

You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated.
Stefi

€� ezt Ã*rta:

Thanks all.
Very simple and works fine.

regrds,
Johan