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

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.

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