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

Auto-copy formating of cells
-
-
-
Hello,
Attached is your test file
Hope this will help
-
Hello,
Once you have tested the formula ... feel free to share your comments
-
Thanks for the Like
-
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
-
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!
Thank you again -
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!
Thank you againYou are absolutely right !!!
Sorry for not having properly and fully explained the proposed solution