View original (French)

=Si la cellule A1 a du texte = B1 devient couleur

jsecours Posted messages 5 Status Membre -  
 huhh -
Bonjour,

Je suis à la recherche d'une formule à double volet :

Dans la même formule :

Si la cellule A1 contient la lettre P = cellule B1 devient bleue OU toujours la cellule A1 contient la lettre D la cellule devient rouge.

Est-ce que quelqu'un peut m'aider ?

Merci

Julie

2 answers

Answer 1 / 2
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 781
 
Hello,

A formula does not change the color of a cell.

For that, you need to use conditional formatting (CF):
Home / Conditional Formatting / New Rule ...
Apply formatting only to cells that contain
Specific Text / containing / P
Format / Fill / Blue

And add another CF for D red

--
Best regards
Patrice
4
jsecours Posted messages 5 Status Member 2
 
Yes, that's fine, I can do that to automatically color a cell. It's coloring another cell based on a specific text that's not working, right?
2
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 781
 
MFC in B1 using a formula
Formula of the type:
=IF(ISERROR(SEARCH("P",$A1)),FALSE,TRUE)
0
huhh > Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention  
 

ftggrfcgr't

0
huhh
 

wxtjgj(t'v'(t

0
Answer 2 / 2
DjiDji59430 Posted messages 4294 Registration date   Status Member Last intervention   715
 
Hello,
Use conditional formatting

Best regards
2
huhh
 

zdfc

0
huhh
 

dbxc'(yh(èyfgkb

0