View original (French)

If B1=yes A1=yellow

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

2 answers

  1.
    jordane45 Posted messages 30426 Registration date   Status Moderator Last intervention   4 830
     
    Hello,

    You just need to use Conditional Formatting.

    --
    Best regards,
    Jordane
    0
  2. PapyLuc51 Posted messages 4569 Registration date   Status Member Last intervention   1 511
     
    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