View original (French)

Cell color based on character count

Solved
mtygolu -  
 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 Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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
      1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482 > Mtygolu
         
        Yes, by replacing NBCAR with its English equivalent...
        0
    3. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello
      =LEN(cell)>40
      crdlmnt
      0