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.

I will suggest you to use "Conditional Formatting" instead.

"Dave" wrote:

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.

I have used the conditional support in b1 I wanty a1 to coincide with the
changes made in b1 to be implemented in a1.

"RajKohli" wrote in message
...
I will suggest you to use "Conditional Formatting" instead.

"Dave" wrote:

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.

See the following link, and let us know if helpful:

http://www.winplanet.com/article/1842-.htm

I think the only way could be Conditional Formatting. Try it with another way.

"Dave" wrote:

I have used the conditional support in b1 I wanty a1 to coincide with the
changes made in b1 to be implemented in a1.

"RajKohli" wrote in message
...
I will suggest you to use "Conditional Formatting" instead.

"Dave" wrote:

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.