Highlight strings longer than 16 characters

**questionasker10101** · 03-09-2022, 03:20 PM

Hello! I am quite new to Excel and am looking for the most straightforward way to solve highlighting red a string if it's longer than 16 characters.

I've tried going into Format > Conditional Formatting > Rule: Formula LEN(A2) > 16, format Red, but it's... not working? I'm not really sure what to do from there. I'm not sure if the issue is my syntax or if I'm not applying this format correctly. I've tested it with a string longer than 16 characters and it did not highlight red. I'd eventually like to apply this formula to an entire column.

Thanks so much!

**6StringJazzer** · 03-09-2022, 03:24 PM

I think you're on the right track, not sure why it didn't work for you. You may have an issue with a conflict between your formula and the "Applies To" range for that rule.

If you want to apply it to an entire column, such as A, first select the entire column, then add the following rule:

=LEN(A1)>16

Format red

That should do it.

If that still doesn't help please attach a sample file.

**questionasker10101** · 03-09-2022, 03:46 PM

worked thanks! I think i had too many underneath, deleted some. I didn't realize they were all applied

**6StringJazzer** · 03-09-2022, 05:13 PM

You're welcome!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

Highlight strings longer than 16 characters

LinkBack

Thread Tools

Rate This Thread

Display

Highlight strings longer than 16 characters

Re: Highlight strings longer than 16 characters

Re: Highlight strings longer than 16 characters

Re: Highlight strings longer than 16 characters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extracting IP Addresses from Longer Strings

[SOLVED] Extract strings from a longer text string

[SOLVED] loop to match if shorter strings appears in longer strings

See if column of shorter strings appears in column of longer strings

Find and Replace for longer strings?

Pass text strings longer than 255 characters

Vlookup name within longer text strings

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions