At each color change in A1, how can B1 also change ?

[Jiby]

Let's say I have the word "Cookie" in cell A1.
If I write "=A1" in cell B1, I will get a dynamic copy of
the content of A1. If I write "Biscuit" in A1, then B1
will immediately turn to "Biscuit". Perfect.
My question is : if I change the background color or text
color in A1, how can I make B1 to automatically follow
these color changes ?
Surely with a function written in VBA, but I can't write
VBA... Who can help me ?
(I know that Copy/Paste will work, but I don't want to
update B1 manually ; I want something dynamic).
Thanks,
Jiby

 

[jr]

use a conditional format:
FORMAT | CONDITIONAL FORMATTING ....
it's self explanatory.

 

[David McRitchie]

I don't think it is self explanatory, in fact the "show me" would require
changing my security options for windows. I have a web page on the subject
http://www.mvps.org/dmcritchie/excel/conffmt.htm
--