View original (French)

If contains text then ...

Flomrn -  
yclik Posted messages 3865 Registration date   Status Membre 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 réponses

Réponse 1 / 2
brucine Posted messages 24389 Registration date   Status Membre Last intervention   4 098
 

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
Réponse 2 / 2
yclik Posted messages 3865 Registration date   Status Membre Last intervention   1 603
 

Hello

or

 IF(ISTEXT($A2))
0