View original (French)

Excel : color cell with LEN

Dfordanger Posted messages 8 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I'm new to Excel and I'm trying to create a conditional formatting rule with the following formula:

=LEN(A1:Q256)>50

The goal is to automatically highlight in green each cell in the range (A1:Q256) that contains a string of more than 50 characters.

Thank you in advance for your help and have a great day everyone!

Configuration: Windows XP / Firefox 3.6.13

3 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    Select the entire range A1:Q256
    the formula is:
    =LEN(A1)>50
    (and not the entire range)
    The conditional formatting will apply to each cell;
    thank you

    Let's ask ourselves if we are the only ones who understand what is being explained?
    2
  3. Dfordanger Posted messages 8 Status Member
     
    Hello elektrotabi,

    Thank you for your reply.

    I’ve thoroughly searched this site, which is quite comprehensive, in vain... My search continues!
    0