If / then statement for character length within a cell

[kerrya98]

Hi everyone,
My first post here on the forum. Am hoping to find a snippet of code to include in my macro that looks thru a column of text and alerts me (preferrably by just coloring the cell) if the cell is larger than 66 characters. The cell will always only contain a string of text.

It will look something like this in column "E":

COPPELL TEX INDPT SCH DIST
WASHINGTON ST
ALABAMA ST PUB SCH & COLLEGE AUTH
JOHNSON CNTY KANS CMNTY COLLEGE STUDENT COMMONS & PKG SYS REV
HAWAII ST
ILLINOIS HSG DEV AUTH REV
SNOHOMISH CNTY WASH SCH DIST NO 015 EDMONDS

I gave something like this a try, but no cigar.... Any help appreciated!

Please Login or Register  to view this content.

[Richard Buttrey]

Why complicate the process with a macro when it's far simpler to apply a conditional format to the range in question?

Never use VBA when there is bog standard Excel functionality.

[kerrya98]

Richard,
Thanks for your reply. Of course. I was just not aware of a conditional cell formatting that could count characters inside the cell.
Kerry

[Richard Buttrey]

Conditional format formulae are no different to formulae you enter directly on the sheet. Usually you are getting them to evaluate to a True or False. So in your case

=LEN(A1)>66

[kerrya98]

Thanks Richard, although again would love if it didn't return false but returned a green color cell.

[Richard Buttrey]

Hi,

Not sure what you mean.

It sounds like you entered that formula directly in a cell. You should be entering it in the conditional format FOR that cell.

[kerrya98]

Solved! Got it into a nice little macro if anyone else needs something like this!

Please Login or Register  to view this content.

[Cutter]

@ kerrya98

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

Based on your last post it seems that you solved your problem on your own but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

[kerrya98]

Thanks for the head's up. Will do all that in the future!