View original (French)

If contains text then ...

Flomrn -  
yclik Posted messages 3875 Registration date   Status Member Last intervention   -

Hello, I'm stuck on a formula; I would like cells to be grayed out when I enter text in the previous one. Let me explain:

If A1 is Jérôme, then A2 and A3 get grayed out ...

Help me

2 answers

  1.
    brucine Posted messages 24940 Registration date   Status Member Last intervention   4 178
     

    Hello;

    I can't figure out which cell or cells are affected by the formula, you need to use VBA, which I don't understand and I'm avoiding it.

    If I want, for example, A2 to be grayed out (I can extend the selection), I create a conditional formatting, formula, =FIND("Jérôme",A1), format, fill, I choose the gray I like.

    0
  2. yclik Posted messages 3875 Registration date   Status Member Last intervention   1 611
     

    Hello

    or

     IF(ISTEXT($A2))
    0