View original (French)

Excel : color cell with LEN

Dfordanger -  
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 Contributor
    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
    2. Dfordanger Author
      Hello elektrotabi,

      Thank you for your reply.

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