If b1 had green text how would i get a1 to copy that colour automatically.
If it was changed in b1, a1 would automatically update itself.