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.
thak you for your help.
Version of Excel?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
=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.
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