View original (French)

Cell color based on character count

Solved
mtygolu -  
Hello everyone,
I have an Excel sheet extracted from software with hundreds of rows and columns
I would like to identify by color all the cells that have more than 40 characters

For example, if my cell A19 has more than 40 characters, the cell color automatically changes to blue

How to proceed, thank you

Configuration: Windows 7 / Firefox 42.0

2 answers

  1. Mtygolu
    Okay, I'll see that tomorrow at work

    Thanks for all of this...
    1
    1. Mtygolu
      Great, that's exactly what I needed

      Thank you
      0
  2. Vaucluse Contributor
    Hello

    select the entire range to process
    ribbon / home / conditional formatting / new rule
    "use a formula"
    enter the formula:

    =LEN(cell)>40

    cell being the address of the 1st cell in the top left of the range, (without the $ sign)

    click on format / format and OK / OK

    best regards

    --
    To err is human, to persist is diabolical.
    0
    1. Mtygolu
      Beautiful, it's exactly what I need
      thank you very much for the result and the quick response
      0
    2. Mtygolu
      However, I forgot an important detail
      It works for me, but I have to use it on an Excel in English
      Will the formula be the same then?
      0
    3. Raymond PENTIER Contributor
      @MtygoluYes, by replacing NBCAR with its English equivalent...
      0
    4. Vaucluse Contributor
      Hello
      =LEN(cell)>40
      crdlmnt
      0