Link to home
Start Free TrialLog in
Avatar of sud
sud

asked on

Excel-count character in cel

For a column I want to highlight cell that are more then 40 character ? The macro should work for a column only and not whole worksheet.

thak you for your help.
Avatar of ISO30
ISO30
Flag of United States of America image

Version of Excel?
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can do it simply by using a Conditional Formatting on that column with a rule where you put a formula like this:

=LEN(A1)>40

Please take a look at the attached image and sample file.

jppinto
Capturar.JPG
Conditional-Formatting-LEN.xls.xlsx
I've requested that this question be closed as follows:

Accepted answer: 500 points for answer_dude's comment http:/Q_27032341.html#35741519

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
The OP asked for a macro so that is what I gave. I should at least get a split....unless the OP changes his mind.
As above