Coloring a datafield when nr of characters is more then 40
 

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

Coloring a datafield when nr of characters is more then 40
 

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

Coloring a datafield when nr of characters is more then 40
 

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

Coloring a datafield when nr of characters is more then 40
 

Thanks all.
Very simple and works fine.

regrds,
Johan

Coloring a datafield when nr of characters is more then 40
 

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