How to Highlight Cells Greater Than a Certain Length in Excel

This post will guide you how to highlight a cell that contains more than a certain length using Conditional Formatting function in Excel. How do I highlight cells greater than or less than a certain text length in Excel.

Highlight Cells Based on Text Length


Assuming that you have a list of data in range A1:A6, in which contain text values. And you want to highlight All cells in red color if the cell length is more than 6 characters in it. How can I do it. You can use the Conditional Formatting function with the LEN function to achieve the result of Formatting Cells in selected range that containing more than 6 characters. Here are the steps:

#1 select the range that you want to highlight cells based on text length.

highlight cells based on cell lenght1

#2 go to HOME tab, click Conditional Formatting command under Styles group. And click New Rule from the popup menu list. And the New Formatting Rule dialog will open.

highlight cells based on cell lenght2

#3 choose Use a formula to determine which cells to format option under Select a Rule Type section in the New Formatting Rule dialog box. Then enter this formula =LEN(A1)>6 into the Format Values where this formula is true text box. Note: the Cell A1 is the first cell of your selected range.

highlight cells based on cell lenght3

#4 click Format button in the New Formatting Rule dialog box, and the Format Cells dialog will open. And switch to Fill tab, choose red color as you need in the Background Color list. Click OK button.

highlight cells based on cell lenght4

#5 click Ok button to apply those changes.

highlight cells based on cell lenght5

#6 you would notice that all cells in range A1:A6 that contain more than 6 characters have been highlighted in red color.

highlight cells based on cell lenght6

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar