Auto-copy formating of cells

    Hello,

    I have been learning excel and found it interesting using the functions. Doing so, stuck in a situation and I am here again seeking for some help.
    Please fetch the attached file for perusal. My Team.xlsx

    Intro :
    Column A : Name of member
    Column B : Activity Status (Active, Idle, Left)
    Using conditional formating I have set colour codes to the Column B to Green, Yellow, and Red respectively.

    Problem :
    I wish to set the cell format of all the names in column A to automatically copy to the adjoining cell format as in column B.
    So as when I update the data in column B, the format of the respective person should be automatically updated.

    Please guide me.
    Thanks

    Hello,


    Once you have tested the formula ... feel free to share your comments

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

    Heyy buddy, that formulas helped.


    I am preparing this sheet on a professional level and I dont want a dummy or a reference column to show up and spoil the datasheet. Of course I can hide the reference column, but I was looking for an alternative solution.
    Offset command helped me achieve the formatting of column A directly and I no longer needed the Column C.

    Thank you for your guidance. It helped. :)

    Glad to hear you could solve your problem :)


    Column C was only shown to let you see your formula and double-check the result ;)


    Thanks for your Thanks

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

    When sending me the file earlier, you could have mentioned in the reply that the column C was a double-check and didnt stand a role in the formula.


    So in that case, your solution was perfect! :love:

    Thank you again :thumbup:

    Quote from digitalricho

    When sending me the file earlier, you could have mentioned in the reply that the column C was a double-check and didnt stand a role in the formula.


    So in that case, your solution was perfect! :love:

    Thank you again :thumbup:


    You are absolutely right !!!


    Sorry for not having properly and fully explained the proposed solution ?(

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)