In A3 enter the formula
=IF(ISBLANK(A2),A1,A2)
For cell A3 use conditional formatting with IsFormula
=$A$3=$A$1
and make the conditional format blue text, for example.
A3 will then be blue if the value is from A1, otherwise it will be the standard format.
HTH
teylyn
Bookmarks