The only thing that changes colour when you enter the text is the actual text colour; the colour will, however, change to white again if you don't enter any text or if, having input something into the cell, you go back to change it. In the latter case, you'll have to reselect the Relationship from the dropdown.

As for changing the colour of the 'next' cell, that's quite easily done, though the code for that depends on whether that 'next' cell is on the same row.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]