Auto Select Cell Value

Thanks for all your help. Sorry about the double posting.

I have 3 columns, A1, A2 and A3

I would like A3 to show me the value of A1 unless there is a value in A2 then it would show the value of A2 instead.

I would also like to change the text color to reflect which cell the value comes from.

Any help would be appreciated.