Menu principal
Moteur de recherche
Rechercher
Menu principal
Forum
Bureautique
Développement
Internet
Jeux vidéo
Matériel
Réseau
Vidéo/TV
Virus/Sécurité
CCM
CCM - Comment Ça Marche - Communauté informatique
Moteur de recherche
Rechercher
Connexion
Posez votre
question
Informatique
Mobile
Applis & Sites
Image & Son
Maison
Securité
Téléchargement
Forum
Bureautique
Développement
Internet
Jeux vidéo
Matériel
Réseau
Vidéo/TV
Virus/Sécurité
Emploi
Forum
View original (French)
If B1=yes A1=yellow
mart2015
Posted messages
14
Status
Membre
-
PapyLuc51
Posted messages
4565
Registration date
Status
Membre
Last intervention
-
23 Jan 2020 at 06:50
Hello
I have to do it for the entire column A
Thank you
Show more
Liens connexes:
Excel IF function on empty cell range
EXCEL: if A1= a word, then B1= colored cell
Excel: sum of "yes" values
EXCEL Calculate the number of YES and NO
=If cell A1 has text, then B1 changes color
What function to perform in B1 related to A1
2 réponses
Réponse 1 / 2
jordane45
Posted messages
30426
Registration date
Status
Modérateur
Last intervention
4 830
Hello,
You just need to use Conditional Formatting.
--
Best regards,
Jordane
Réponse 2 / 2
PapyLuc51
Posted messages
4565
Registration date
Status
Membre
Last intervention
1 510
Hello,
To complement the response from
jordan45
Regards
see this image
Note: it might not work on the first try, so reopen the MFC manager and modify the formula by removing any extra quotes that may have been added.
Best regards
Latest Discussions
Windows spotlight is not working.
at 15:08
Masked destination layer
at 14:40
Samsung j5 unable to answer
on 19 May
Scam of the suvedene highway
on 18 May
File name too long
on 17 May
No sound with ps3 and hdmi
on 17 May
Wake up from sleep mode in windows 10.
on 17 May
Internet connection problem with my ipad
on 17 May
Free box: remote control broken
on 17 May
Suspicious number text message
on 17 May
Other languages
🇫🇷
Français