Coloring a datafield when nr of characters is more then 40

J

jmslab

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
 
D

Dave Peterson

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.
 
S

Stefi

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


Regards,
Stefi

„[email protected]†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula for counting nr records with data and related empty fields 3
Excel, Marking a field when text is not like required 2
Excel chart, set a vertical baseline on a certain date 1
Datafield which shows the logged in users 2
Marking records with mismatched data 2
Counting number of unique datafields in a column 2
Enable automatic popup when entering data 0
Excel module: Mark records if it contains names out of another list 4

Top