Announcement

Collapse
No announcement yet.

Format Color Of Cell Based On Number Of Characters

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Format Color Of Cell Based On Number Of Characters



    Is it possible to base conditional formatting on text length?

    I want to highlight any cell in a column where there is an entry more than 3 characters long. The values entered into this column will always be one of the following layouts:

    KD ie 2 letters
    KNH ie 3 letters
    KD/KNH (10%) ie a combination of 2 or 3 letters, followed by a forward slash, followed by 2 or 3 letters, followed by a percentage in brackets

    Basically, the column will usually have 2 or 3 letters entered in each cell, but I want my attention to be drawn to a cell if there is going to be more than 3 characters in it.

    many thanks

  • #2


    Re: Conditional Formatting Based On Number Of Characters In A Cell

    Use Formula Is: =LEN(A1)>3

    Comment

    Working...
    X