W wilko Nov 10, 2009 #1 get cell to automatically change colour depending on text in adjacent cell, can anyone help?