If B1=yes A1=yellow

mart2015 Posted messages 14 Status Membre -  
PapyLuc51 Posted messages 4565 Registration date   Status Membre Last intervention   -
Hello
I have to do it for the entire column A
Thank you

2 réponses

jordane45 Posted messages 30426 Registration date   Status Modérateur Last intervention   4 830
 
Hello,

You just need to use Conditional Formatting.

--
Best regards,
Jordane
0
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
0